formatting of SQL sent by PHP to postgres

From: Ken Guest <kguest(at)stockbyte(dot)com>
To: Postgre General <pgsql-general(at)postgresql(dot)org>
Subject: formatting of SQL sent by PHP to postgres
Date: 2003-10-30 14:51:32
Message-ID: 1067525492.25954.10.camel@kguest.local.stockbyte.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
________________________________________________________________________

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-10-30 14:52:22 Re: Transaction Performance Question
Previous Message scott.marlowe 2003-10-30 14:47:00 Re: pg_ctl vs full restart