spliting search results 10 by 10
Posted: Sat Oct 21, 2006 12:00 pm
This might been asked like dozens of times, though i performed a searched and didnt find so much.
i want to perform a search in a database and then show the results 10 each time, like google and friends do.
Thats ok, i limit the result, make pagination etc etc...
now my biggest issue is performance.
like... if perform a search that returns 10000 results, 10000 row will be selected.
Is there any way i can get the number of matches without slow down the whole thing?
thanks in advance.
i want to perform a search in a database and then show the results 10 each time, like google and friends do.
Thats ok, i limit the result, make pagination etc etc...
now my biggest issue is performance.
like... if perform a search that returns 10000 results, 10000 row will be selected.
Is there any way i can get the number of matches without slow down the whole thing?
thanks in advance.