Page 1 of 1

Difficulty in fetching the data from the database ?

Posted: Thu Aug 12, 2010 3:08 am
by Yuvarajj
We have developed an application using PHP/ MySQL, which we found difficulty in fetching the data from the database? (i.e it contains around 8000 Records in a table), It gets very slow on the local host. Is there any possible for quick fetching the DB?

Re: Difficulty in fetching the data from the database ?

Posted: Thu Aug 12, 2010 10:21 am
by Gargoyle
only pull the rows you need, not the entire table.

Re: Difficulty in fetching the data from the database ?

Posted: Thu Aug 12, 2010 11:03 am
by mikosiko
post the code/ query that you are using... and your table description