| How to Join | Member's Area | Private Library | Search | Sanctuary | Login | |
|---|---|---|---|---|---|---|
| Main Forums | Discussion | Tech Talk | Mature Content | Archives |
A home without a wall, |
|
|
||||||
| How to Join | Member's Area | Private Library | Search | Sanctuary | Login | |
|---|---|---|---|---|---|---|
| Main Forums | Discussion | Tech Talk | Mature Content | Archives |
A home without a wall, |
|
|
|
||||||
| Geek Stuff |
|
Mysql, Php and performance |
|
|
Parker Member Elite
since 2000-01-06
Posts 3129ON |
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 |
||
| © Copyright 2004 James Haley - All Rights Reserved | |||
|
|
⇧ top of page ⇧ |
|
| All times are ET (US). All dates are in Year-Month-Day format. | ||
