[unixODBC-support] Problem in using cursor to fetchmillionsofrows
jlam at sandvine.com
Thu Apr 7 04:28:26 BST 2005
It behaves exactly the same, ~129M. I just purely run isql with the select statement inside isql interative mode.
From: unixodbc-support-bounces at easysoft.com
[mailto:unixodbc-support-bounces at easysoft.com]On Behalf Of Eric Sharkey
Sent: Wednesday, April 06, 2005 11:14 PM
To: Support for the unixODBC project
Subject: Re: [unixODBC-support] Problem in using cursor to
> After I turned on the trace mode as Eric told me, I found out that the execution hung at SQLexecute for about 20 secs, then it starts to fetch the rows. By that
> time, it consumes already 132meg.... Any idea??
Try the same query with the same driver, but use isql rather than
tcl and see how its memory usage goes.
unixODBC-support mailing list
unixODBC-support at easysoft.com
More information about the unixODBC-support