Querying...

[MemphiS]

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 =)

[thedarkwinter]

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

[fenway]

The query or the page takes one second to load? Post the EXPLAIN output.