Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion

Поиск
Список
Период
Сортировка
От Jochem van Dieten
Тема Re: Performance of ODBC-Driver /w IIS5.0/ColdFusion
Дата
Msg-id 3D26D764.1040203@oli.tudelft.nl
обсуждение исходный текст
Ответ на Performance of ODBC-Driver /w IIS5.0/ColdFusion  ("Markus Wollny" <Markus.Wollny@computec.de>)
Список pgsql-general
Neil Conway wrote:
> On Sat, Jul 06, 2002 at 02:07:34AM +0200, Jochem van Dieten wrote:
>
>>If you have queries returning multiple rows, make sure you have a
>>blockfactor set, this can make up a significant difference. Are you
>>returning text fields in queries? What if you explicitly cast them to
>>varchar fields (SELECT textfield::varchar ...)?
>
> What is the reasoning behind that?

No reasoning, just personal experience with ColdFusion 4.5.1 SP2,
PostgreSQL 7.1, the Windows ODBC driver 7.01.00.06 and query timeouts.

Jochem

--
Jochem van Dieten
Team Macromedia Volunteer fro ColdFusion

http://www.macromedia.com/support/forums/team_macromedia/




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

Предыдущее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: OID Errors
Следующее
От: Tom Lane
Дата:
Сообщение: Re: