|
|
Posted by BearItAll on 06/29/05 18:37
On Tue, 28 Jun 2005 13:53:45 -0700, frizzle wrote:
> Hmm, i've thought of your second option, but i wondered if i could change
> things closer to the information's root ...
> The Mysql version is recent, but i don't know what you mean with subquery.
> I also figured i could get the total possible results, substract number of
> uploaded pictures, and then use that as the offset within Limit.
> Or would that make things slow (in quite a small db)
>
> Thanks again!
I would of said that Andy's pass to an array would be right for the amount
of data you are working on. Alternatively to keep the return from your
query so that you can reuse it, which I think is what you mean from your
post, I would say that using a MySQL temporary table would be just as
reasonable (as good as an array, as they say).
Remember that future re-queries on that sub-set table are going to be much
faster than your original query on the main data table, so that reordering
it for display purposes will have little overhead, or sub filtering for
display.
But still, for your quantity of records then an array may be at least as
good.
Navigation:
[Reply to this message]
|