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

From Ken Guest
Subject formatting of SQL sent by PHP to postgres
Date
Msg-id 1067525492.25954.10.camel@kguest.local.stockbyte.com
Whole thread Raw
Responses Re: formatting of SQL sent by PHP to postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: formatting of SQL sent by PHP to postgres  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
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?

2.    A lot of SQL issued have white space characters (newlines, tabs and
spaces) present - does this have any [major] impact on how quick
postgres gets to execute the SQL and return results?

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: Jeff
Date:
Subject: Re: slow query performance
Next
From: "scott.marlowe"
Date:
Subject: Re: Automatic auditing suggestion