Multiple pages, with no LIMIT

[Lahloob]

Hey,

I need to search the whole database and do some computations on the search result, for relevancy checking... and then display 10 results only.

And once the user clicks on the "Next" button, I knew that my script had to redo the previous computations and get the next 10 results... this is very costly ..

Is there anyway where I can store the result of first retrieval temprarly, and once the user clicks on "Next" .. the result is taken from that buffer.. not from doing the retrieval process again from DB.

is output buffering (ob_start()...etc) useful in this case ? Let's say: 200 retrieved documents... each document is about 30 words with some html formats..

Or is there a method helpful for creating ( temp ) files .. which stores the search result.

You see the key difference here is that the following SQL commands will not be useful : (LIMIT, ORDER BY, GROUP BY) ..

Any help please.

[Pig]

output buffering has nothing to do with what you are talking about. That is a strange situation. I would suggest you do testing to make sure the process is a expensive as you think. You will probably be surprised at what PHP can handle.

Anyway, if you decide to go ahead, probably the easiest way would be to create an array of the results, and store it in a session. Then you can just display the next set like:
$offset = 30;
$display = 10;
for( $i = $offset; $i < ($offset + $display); $i++)
{
$array[$i]
}