How to sort a search result without reexecuting a query?

[K3v1n]

Let's say I get the results from DB and I want to sort them in different ways, but I don't know how to keep its cache so I don't have to do query again...

[RossC0]

You could save the query results into an array - (use getAll() in adodb) then sort the array.

I haven't used this - but it would save you from requerying, but speed wise if your table is well indexed then you might be able to query faster.

Another option which might be fast for MySQL databases - would be to save the results of the query into a Memory (HEAP) table and then query the Memory table.

[K3v1n]

Thanks for the reply.
Could you provide more info about the Memory Table? 😃

[Roger_Ramjet]

Try a little bit of rtfm