[SQL] Re: Re: [SQL] Query Timeout Question

2011-12-08 Thread feng.zhou
pgsql-sql 主题： Re: [SQL] Query Timeout Question On 12/09/2011 09:44 AM, feng.zhou wrote: 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 h

Re: [SQL] Query Timeout Question

2011-12-08 Thread Craig Ringer
On 12/09/2011 09:44 AM, feng.zhou wrote: 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, SQLEx

Re: [SQL] Query Timeout Question

2011-12-08 Thread feng.zhou
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

[SQL] Query Timeout Question

2011-12-08 Thread feng.zhou
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 timeou