Re: Query Timeout Question

From: "feng(dot)zhou" <feng(dot)zhou(at)wellintech(dot)com>
To: "pgsql-sql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Query Timeout Question
Date: 2011-12-09 01:58:23
Message-ID: 201112090958236709111@wellintech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

sorry, timeout is 15 seconds

2011-12-09

feng.zhou

发件人: feng.zhou
发送时间: 2011-12-09 09:25:49
收件人: pgsql-sql
抄送:
主题: [SQL] Query Timeout Question

Hi
I set query timeout in code by using SQLSetStmtAttr ODBC API .

SQLSetStmtAttr( StatementHandle, SQL_ATTR_QUERY_TIMEOUT, (SQLPOINTER)timeout, 0 ) ;
SQLExecute(StatementHandle);

But I find this setting has no effect.Before adding timeout setting, SQLExecute costs 47 seconds.After adding timeout, costing time is same.
Postgres SQL version 8.4.2, ODBC driver 8.4.2

2011-12-09

feng.zhou

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Craig Ringer 2011-12-09 02:27:50 Re: Query Timeout Question
Previous Message feng.zhou 2011-12-09 01:44:45 Query Timeout Question