Re: sorting query results
Brew <[email protected]> Sat, 18 Apr 2009 10:05:03 -0400
| Newsgroups | gmane.comp.db.postgresql.php |
|---|---|
| Message-ID | <[email protected]> |
Piotr...... > 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 > results. > > 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..... brew -- Strange Brew ([email protected]) Check out my Stock Option website http://www.callpix.com and my Musicians Free Classified http://www.TheMode.com -- Sent via pgsql-php mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-php