[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 ?

-- 
Nick



More information about the unixODBC-support mailing list