Speed up php gallery, i have some very slow queries

Cancelled Posted Jun 18, 2012 Paid on delivery
Cancelled Paid on delivery

> My site is a phpbb2 message board with a ton of modifications and an added gallery, i have some caching of the queries in the php files but still very slow

>

> I have attached some slow queries from the msqlslow log and also my main index page and main gallery page so you can see the php

>

> The pic_view_count (dont care about keeping track) pic_fonts pic_lock and pic_approval (every pic is automatically approved when uploaded) and all the pic rating coding are not used at all so if this could be written out of the db and php files it might help

MySQL PHP

Project ID: #2751975

About the project

7 proposals Remote project Active Jul 10, 2012

7 freelancers are bidding on average $238 for this job

meet2amitvw

See private message.

$375.7 USD in 5 days
(80 Reviews)
7.9
gopisoft

See private message.

$450.5 USD in 5 days
(56 Reviews)
5.6
mastirlaa

See private message.

$400.35 USD in 5 days
(26 Reviews)
4.8
datadiggerssl

See private message.

$40.8 USD in 5 days
(1 Review)
1.4
shirinkhan

See private message.

$100.3 USD in 5 days
(1 Review)
1.3
demarlosindia

See private message.

$200.6 USD in 5 days
(0 Reviews)
0.0
castro1688

See private message.

$100.3 USD in 5 days
(0 Reviews)
0.0