formatting of SQL sent by PHP to postgres

Поиск
Список
Период
Сортировка
От Ken Guest
Тема formatting of SQL sent by PHP to postgres
Дата
Msg-id 1067525492.25954.10.camel@kguest.local.stockbyte.com
обсуждение исходный текст
Ответы Re: formatting of SQL sent by PHP to postgres
Re: formatting of SQL sent by PHP to postgres
Список 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 по дате отправления:

Предыдущее
От: Jeff
Дата:
Сообщение: Re: slow query performance
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Automatic auditing suggestion