craig curtin
November 3rd, 1998, 09:58 AM
hi,
i have a VC5.0 COM object (that uses DAO) that is used within a VB4.0 application. i get the dreded "run-time error '28' out of stack space" when my application is parsing a large database using DAO.
basic COM object function:
the COM object reads in text files, parses them and creates/opens/updates the DB appropriately. everything works fine till my input files get large (works when they are ~300Kb, blows when >325Kb, this is approximately 5000 DAO records).
i think this puts a burden on the JET engine.
few questions:
- seems the stack size of my component runs on the VB stack, can i increase the
size of the VB stack? (changing my components stack size doesn't seem to make a difference)
- i ran the VB app (w/my control) through BoundsChecker and it reported "minor" leaks, and most of them were in DAO. is there anything i can do to make DAO conserve more memory? or to have DAO free up its memory (yes, i'm closing/flushing the recordSets/tables when i am done with them)
- do my record size exceed the limits of JET/DAO? anyone know how to find the limits?
i have a VC5.0 COM object (that uses DAO) that is used within a VB4.0 application. i get the dreded "run-time error '28' out of stack space" when my application is parsing a large database using DAO.
basic COM object function:
the COM object reads in text files, parses them and creates/opens/updates the DB appropriately. everything works fine till my input files get large (works when they are ~300Kb, blows when >325Kb, this is approximately 5000 DAO records).
i think this puts a burden on the JET engine.
few questions:
- seems the stack size of my component runs on the VB stack, can i increase the
size of the VB stack? (changing my components stack size doesn't seem to make a difference)
- i ran the VB app (w/my control) through BoundsChecker and it reported "minor" leaks, and most of them were in DAO. is there anything i can do to make DAO conserve more memory? or to have DAO free up its memory (yes, i'm closing/flushing the recordSets/tables when i am done with them)
- do my record size exceed the limits of JET/DAO? anyone know how to find the limits?