I have a simple application written in vb6 that extracts contents of
an ASA8 database to an XML file, running on Windows NT4. I have found that it eats memory on
the subset of data I am testing with, and calculate it will use 1Gb
Memory to extract the whole set of data!
I therefore set about finding the memory leak and have discovered it
has something to do with the ODBC driver. If I dump the relevant data
into an MS Access database and use that as the datasource I get a huge
difference in performance/memory usage. ie:
ASA8 (v8.00.00.2065) mem usage: 110360K, handles: 48823
MSAccess mem usage: 6876K (peak 9800K),handles: 38 (yes
I have created a simple vb6 program to reproduce this problem. It
opens the database, runs a select statement, closes the database and
loops round. Again, using Access I get much lower memory usage:
ASA8 (v8.00.00.2065) mem usage: 15216K, handles: 3045
MSAccess mem usage: 5572K, handles: 35
Example code below.
Can anyone help me with this? Is there a bug in the ASA8 odbc driver
v8.00.00.2065 which doesn't release memory?
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim fField As Field
Dim i As Long