Is there a way to set the timeout for an SQL query?
lazarus / 16-Databases

----------------------------------------------------------------------
vfclists · 2012-02-14 21:36

Do the Lazarus database components have an option to set how long a
query should wait for a response, before it considers it to have timed
out? Can it be set at the Connection level, query level or both?

/vfclists

----------------------------------------------------------------------
Lacak2 · 2012-02-15 07:53

Which connection component do you use ?
(TMySQLConnection, TPQConnection, ...)

----------------------------------------------------------------------
vfclists · 2012-02-15 13:12

I am using Zeos components, TZQuery and TZConnection with PostgreSQL
Quote from: Lacak2 on February 15, 2012, 08:53:03 amWhich connection
component do you use ?
(TMySQLConnection, TPQConnection, ...)

----------------------------------------------------------------------
Lacak2 · 2012-02-15 13:37

I do not use Zeos, but looking at PostgreSQL documentation, there is
statement_timeout(integer) configuration option.
So you can try execute this SQL (for example) :
"SET statement_timeout = 10000"