Re: [GENERAL] formatting of SQL sent by PHP to postgres

2003-10-30 Thread scott.marlowe
On Thu, 30 Oct 2003, Ken Guest wrote: > Folks, > I have a question or two regarding PHP and Postgres on the issue of > speed: > 1.Is the semicolon at the end of SQL superflous when sent to Postgres? > Should it make much of a difference if I removed it? Yes, you can get rid of it. No, it won

Re: [GENERAL] formatting of SQL sent by PHP to postgres

2003-10-30 Thread scott.marlowe
On Thu, 30 Oct 2003, David Green wrote: > > On Thu, 30 Oct 2003, 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 de

Re: [GENERAL] formatting of SQL sent by PHP to postgres

2003-10-30 Thread David Green
On Thu, 30 Oct 2003, 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..." When I first read this I was su