This is my problem:
I have a project in VB that uses DCOM to call SAP. I use the BAPI GeneralLedgerAccount to retrieve accounts from SAP. In SAP I have a total of approx 8000 accounts.
The function goes as this:
Declare objects and recordsets needed.
Call own database to create recordset of companies (SQL 7.0 local installation)
For every company in my database I retrieve a list of accounts (GetList)
For every account I retrieve the details (GetDetail)
The details are inserted one at a time in my database.
My computer (~400MB RAM) runs out of memory when about 4500 account details have been retrieved and inserted.
Checking from the Task Manager I can see that it is DLLHOST.EXE that is eating up the memory at a horrible speed...
I have tried destroying recordsets in between calls, changing all possible ways of calling the functions without any improvement. I'm quite sure (??) that I do not have any extra loops in my code generating this problem.
I would be very happy if anyone could direct me towards a solution.
Thanks,
Mats
P.S. Apologies for the long explanation...
I have a project in VB that uses DCOM to call SAP. I use the BAPI GeneralLedgerAccount to retrieve accounts from SAP. In SAP I have a total of approx 8000 accounts.
The function goes as this:
Declare objects and recordsets needed.
Call own database to create recordset of companies (SQL 7.0 local installation)
For every company in my database I retrieve a list of accounts (GetList)
For every account I retrieve the details (GetDetail)
The details are inserted one at a time in my database.
My computer (~400MB RAM) runs out of memory when about 4500 account details have been retrieved and inserted.
Checking from the Task Manager I can see that it is DLLHOST.EXE that is eating up the memory at a horrible speed...
I have tried destroying recordsets in between calls, changing all possible ways of calling the functions without any improvement. I'm quite sure (??) that I do not have any extra loops in my code generating this problem.
I would be very happy if anyone could direct me towards a solution.
Thanks,
Mats
P.S. Apologies for the long explanation...