Re: formatting of SQL sent by PHP to postgres

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: formatting of SQL sent by PHP to postgres
Дата
Msg-id 28355.1067528677@sss.pgh.pa.us
обсуждение исходный текст
Ответ на formatting of SQL sent by PHP to postgres  (Ken Guest <kguest@stockbyte.com>)
Список pgsql-general
Ken Guest <kguest@stockbyte.com> writes:
> 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; no.

> 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?

No.  I doubt you could measure the impact at all ... unless you are
talking many kilobytes of whitespace, in which case the data
transmission overhead might be noticeable.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: slow query performance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: dump schema schema only?