[unixODBC-support] Problem in using cursor to fetchmillionsofrows
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