MemphiS Posted August 16, 2007 Share Posted August 16, 2007 currently im retreiving info like so: <code> <?php $result = mysql_query("SELECT `id` , `la` , `laa` , `etc` FROM `table` WHERE `accepted` = '1' ORDER BY `points` LIMIT $limit1, $limit2"); while ($row = mysql_fetch_row($result)){ echo.. data out includes a table for each row of data.. } ?> Currently it displays 50 results and is past the 1 second just to load. Is there a faster way of retreiving the data? Thanks for your reply =) Link to comment https://forums.phpfreaks.com/topic/65204-querying/ Share on other sites More sharing options...
thedarkwinter Posted August 16, 2007 Share Posted August 16, 2007 The php method i would say is fine, if you want to spead up the database, you should look into indexing your tables. But 1 second for 50 rows is not bad Link to comment https://forums.phpfreaks.com/topic/65204-querying/#findComment-325586 Share on other sites More sharing options...
fenway Posted August 21, 2007 Share Posted August 21, 2007 The query or the page takes one second to load? Post the EXPLAIN output. Link to comment https://forums.phpfreaks.com/topic/65204-querying/#findComment-330375 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.