> I recognized two
> ways of doing that: (sorting results)
> 1. Issue a new query to the database each time the specific sorting was
> requested. In other words, let the database do the sorting and fetch the
> 2. Save the table into php array and and use php built-in functions to sort
> and refresh the table.
> Which of those methods would be most desired in terms of performance and
> according to "the best practices"?
> What would be possible drawbacks/advantages of those methods.
I'd do it in within the database query, it's just a little bit of
programming, probably just add 'ORDER BY' to your statement. Possibly
more, but if you have a real complicated query you'll be spending a
bunch of time getting it right anyway.
If it's slow, then you start to optimize the query.
At any rate, that's the way I do it.....
Strange Brew (brew(at)theMode(dot)com)
Check out my Stock Option website http://www.callpix.com
and my Musicians Free Classified http://www.TheMode.com
In response to
pgsql-php by date
|Next:||From: Piotr Mitoraj||Date: 2009-04-18 14:34:26|
|Subject: Re: sorting query results|
|Previous:||From: Piotr Mitoraj||Date: 2009-04-18 13:03:59|
|Subject: sorting query results|