Database is Informix 9.2. I have a query that if the execution time
exceeds 30 seconds, I get no result set. I do not receive any errors,
nothing is logged in the log files. The RecordCount is 0. If the query
executes in less than 30 seconds, I get the result set. This query is a
query of patients based on input from a form. If you use the name SMITH
in the query, it takes 41 seconds to process the query with recourdcount
= 0. If I copy the sql from the debug info and run it in ISQL
(informix-SQL) , 505 records returned. What am I doing wrong??????
Barry Lloyd
SC. Dept. of Mental Health
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
