llblgen pro 1.0.2005.1 Final
Oracle 10G Express
.net 1.1
I am having performance issues with importing data into database.
The process imports many 1000's of records. Each individual record could have a corresponding child row that belongs to 1 of 10 child tables.
In llbl speak: each one of the parent entities has one child collection that receives one entity only.
I am using the UnitOfWork object to speed things up. However, LLBL continues to hit the database the whole time between commit calls.
There doesn't seem to be a way to stop db activity. When I "Add" entities to the colletions, database calls are from GetMulti, etc. To fix that, I set DoNotPerformAddIfPresent = false. That makes adding to collections faster. This doesn't help me overall because for some reason setting this flag to false llbl must call get_childCollection to access the property via parent entity and that causes a database query. I have to set DoNotPerf.. = false for every parent row, which slows things down.
Bottom line, I don't want any database activity until i call unitOfWork.Commit.
I'd appreciate any replies.
-Thanks