[unixODBC-support] Problem in using cursor to fetchmillionsofrows

Jerry Lam 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. 



-----Original Message-----
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 mailing list