[unixODBC-support] Problem in using cursor to fetchmillionsofrows

Nick Gorham nick.gorham at easysoft.com
Thu Apr 7 18:35:53 BST 2005

Jerry Lam wrote:

>Yes, the memory usage stay fixed. It released a portion back to the OS when I call "db disconnect" about 80M. It hurts because it used 166M of memory and I'm expected it to use much less than that ~20M since I want 1 row at a time by using the cursor.

And does it still do the same using isql ?

I have just returned 39286 rows in isql from postgres and the memory 
usage of isql doesn't go about 31mb. Are there any blobs or long 
datatypes in the table ?


More information about the unixODBC-support mailing list