How to Join Member's Area Private Library Search Today's Topics p Login
Main Forums Discussion Tech Talk Mature Content Archives
   Nav Win
 Tech Talk
 Geek Stuff
 Mysql, Php and performance
Follow us on Facebook

 Moderated by: Christopher   (Admins )

 
User Options
Format for Better Printing EMail to a Friend Not Available
Admin Print Send ECard
Passions in Poetry

Mysql, Php and performance

 Post A Reply Post New Topic   Go to the Next Oldest/Previous Topic Return to Topic Page Go to the Next Newest Topic 
Parker
Member Elite
since 01-06-2000
Posts 3135
... the old black rum


0 posted 10-20-2004 09:16 PM       View Profile for Parker   Email Parker   Edit/Delete Message      Find Poems   Click to visit Parker's Home Page   View IP for Parker

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
 
 Post A Reply Post New Topic   Go to the Next Oldest/Previous Topic Return to Topic Page Go to the Next Newest Topic 
All times are ET (US) Top
  User Options
>> Tech Talk >> Geek Stuff >> Mysql, Php and performance Format for Better Printing EMail to a Friend Not Available
Print Send ECard

 

pipTalk Home Page | Main Poetry Forums

How to Join | Member's Area / Help | Private Library | Search | Contact Us | Today's Topics | Login
Discussion | Tech Talk | Archives | Sanctuary



© Passions in Poetry and netpoets.com 1998-2013
All Poetry and Prose is copyrighted by the individual authors