Re: formatting of SQL sent by PHP to postgres

Поиск
Список
Период
Сортировка
От Ken Guest
Тема Re: formatting of SQL sent by PHP to postgres
Дата
Msg-id 1067532374.28684.1.camel@kguest.local.stockbyte.com
обсуждение исходный текст
Ответ на formatting of SQL sent by PHP to postgres  (Ken Guest <kguest@stockbyte.com>)
Список pgsql-general
On Thu, 2003-10-30 at 15:34, scott.marlowe wrote:

>
> It's far more likely that optimizing your SQL queries will yield the
> greatest increase in performance.  Things like replacing "select max(id)
> from table" with "select id from table order by id desc limit 1" etc...

that's a neat trick Scott,
Thanks for that and I appreciate your reply :)

k.

--
Ken Guest
Senior Developer
Stockbyte Royalty Free Photos
http://www.stockbyte.com



________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com
________________________________________________________________________

В списке pgsql-general по дате отправления:

Предыдущее
От: "Rick Gigger"
Дата:
Сообщение: Re: Transaction Performance Question
Следующее
От: Jeff MacDonald
Дата:
Сообщение: regular backups - super user