Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Hesitations during retrieval?
1 view
Skip to first unread message
Michael_Ray
Jul 16, 2003, 4:14:17 PM7/16/03
to
Rows are retrieved quickly in blocks of 65 rows, but between these blocks
there is hesitation and at the end of the result set the retrieval seems to
hang for a while (10 seconds to several minutes).
Any suggestions? (Informix UniData ODBC driver).
there is hesitation and at the end of the result set the retrieval seems to
hang for a while (10 seconds to several minutes).
Any suggestions? (Informix UniData ODBC driver).
Using PB 8.0.3. Same sql in Access does not have the problem.
![Andy Turiansky [TeamSybase]'s profile photo](http://lh3.googleusercontent.com/a-/ALV-UjUJBy2LywsgXW2ig0Jra-9utXXjW3sSpQKX4rbB56zbHCwC=s40-c)
Andy Turiansky [TeamSybase]
Jul 17, 2003, 12:41:04 PM7/17/03
to
Try turning on SQL tracing (DBMS = TRACE INF) to see what the query is doing
On Wed, 16 Jul 2003 16:14:17 -0400,
in powersoft.public.powerbuilder.database
0 new messages