Difficulty in fetching the data from the database ?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Yuvarajj
Forum Newbie
Posts: 1
Joined: Thu Aug 12, 2010 2:20 am

Difficulty in fetching the data from the database ?

Post 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?
Gargoyle
Forum Contributor
Posts: 130
Joined: Wed Jul 14, 2010 12:25 am

Re: Difficulty in fetching the data from the database ?

Post by Gargoyle »

only pull the rows you need, not the entire table.
mikosiko
Forum Regular
Posts: 757
Joined: Wed Jan 13, 2010 7:22 pm

Re: Difficulty in fetching the data from the database ?

Post by mikosiko »

post the code/ query that you are using... and your table description
Post Reply