Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group