DB Query Analysis

Closed Posted Dec 14, 2009 Paid on delivery
Closed Paid on delivery

I've put an installation of phpLD at [url removed, login to view] (more info about phpLD at www.phplinkdirectory.com. Our team at phpLD is busy with other tasks, so this is why I am asking here on RAC) It has many subcategories and links. The goal here is the following: 1. Provide a report of the db queries taking place for a few different pages. You should be able to report all the queries, as well as the time for execution. 2. Provide recommendations for ways we could alter the queries to increase load time. 3. Provide recommendations for cron or pseudo-crons we could run that would allow us to pre-run some queries. We are already using caching, so we are looking for some other methods that might allow us to reduced the amount or size of regular queries. I will provide FTP and cpanel access, and can turn on some logs if you need them. Please try to give me some idea of what you plan to do in your reply (because too often we get requests like "I can do this" or "I am ready to start"). :) So please try to provide some info that shows you thought about the work! :) Thanks, David

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):

a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

.

MySQL PHP

Project ID: #3024689

About the project

8 proposals Remote project Active Jan 5, 2010

8 freelancers are bidding on average $252 for this job

vmworks

See private message.

$102 USD in 5 days
(29 Reviews)
5.0
vw6796872vw

See private message.

$382.5 USD in 5 days
(10 Reviews)
4.0
darthsidius

See private message.

$127.5 USD in 5 days
(8 Reviews)
3.5
alienwebsl

See private message.

$204 USD in 5 days
(6 Reviews)
2.7
Monir1234

See private message.

$83.3 USD in 5 days
(7 Reviews)
2.3
raczvw

See private message.

$510 USD in 5 days
(2 Reviews)
0.9
Satyendra070091

See private message.

$8.5 USD in 5 days
(3 Reviews)
0.0
vw6976298vw

See private message.

$595 USD in 5 days
(0 Reviews)
0.0