| From: | Ken Guest <kguest(at)stockbyte(dot)com> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | Postgre General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: formatting of SQL sent by PHP to postgres |
| Date: | 2003-10-30 16:46:14 |
| Message-ID: | 1067532374.28684.1.camel@kguest.local.stockbyte.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
________________________________________________________________________
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2003-10-30 17:37:02 | Re: Sending email from PL/pgsql |
| Previous Message | Rick Gigger | 2003-10-30 16:38:44 | Re: Transaction Performance Question |