Re: formatting of SQL sent by PHP to postgres - Mailing list pgsql-general

From Ken Guest
Subject Re: formatting of SQL sent by PHP to postgres
Date
Msg-id 1067532374.28684.1.camel@kguest.local.stockbyte.com
Whole thread Raw
In response to formatting of SQL sent by PHP to postgres  (Ken Guest <kguest@stockbyte.com>)
List 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 by date:

Previous
From: "Rick Gigger"
Date:
Subject: Re: Transaction Performance Question
Next
From: Jeff MacDonald
Date:
Subject: regular backups - super user