Mysql, Php and performance

How to Join	Member's Area	Private Library	Search	Sanctuary		Login
Main Forums	Discussion	Tech Talk	Mature Content	Archives	A home without a wall, Our haven without ends, A circle we all call Our Family of Friends!

Geek Stuff

Mysql, Php and performance

Parker
Member Elite

since 2000-01-06

Posts 3129
ON

0 posted 2004-10-20 09:16 PM

I seem to be haveing a performance issue on my Php mysql query. with only 800 to 1000 records in my main table, and the equivilant in the other tables it references it just seems to take way too long to display the results. 6 to 10 seconds. Now when I add 300 more to enlarge the table it slows down by atleast 4 more seconds. I'm no expert in this stuff, but that seems like a very small amount of records and it should be sub second response. If I compare it to the pip site which most be huge, mine is so slow.

The question is....

What are the best areas to look at to improve speed and the simplest to implement.

Any help from anyone would be great.

Parker

	⇧ top of page ⇧
All times are ET (US). All dates are in Year-Month-Day format.