[unixODBC-support] Problem in using cursor to fetchmillionsofrows

Jerry Lam jlam at sandvine.com
Thu Apr 7 04:28:26 BST 2005


Hi,

It behaves exactly the same, ~129M. I just purely run isql with the select statement inside isql interative mode. 

Thanks

Jerry

-----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
fetchmillionsofrows 


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

Eric
_______________________________________________
unixODBC-support mailing list
unixODBC-support at easysoft.com
http://mail.easysoft.com/mailman/listinfo/unixodbc-support




More information about the unixODBC-support mailing list