chiprivers Posted March 20, 2010 Share Posted March 20, 2010 The way that I am currently querying my database, I think, is slowing down the displaying of the requested page that I am working on. It is taking around 20 seconds to load! Inorder to display the data in the way I require it, I am running one query which is returning a set of data containing between 10 and 20 records. The result of this query contains some data to display on the page but for each record returned, I am also having to carry out a further query of the database to return several records of another table. The results of this query will return approx 100 records containing data to display. Like I have said, the page as I have coded it so far (which is by no means complete) is taking approximately 20 seconds to load. I am wondering whether there is a more efficient way of extracting the data from the database? I have tried to find some example scripts to produce what I am doing but I have had no success trying to find anything vaguely similar. Link to comment https://forums.phpfreaks.com/topic/195951-is-there-a-more-efficient-way-of-doing-this/ Share on other sites More sharing options...
fenway Posted March 22, 2010 Share Posted March 22, 2010 Too hypothetical -- post EXPLAIN output. Link to comment https://forums.phpfreaks.com/topic/195951-is-there-a-more-efficient-way-of-doing-this/#findComment-1030183 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.