You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have an issue. It looks like something is not cleaned up in the code. Or even worse, something is not reused when it could be reused.
When we do a batch import of many persons over the EF firebird dies because of out of memory. (1.5 GB in 20 seconds)
What I do is making 20000 persons and then call SaveChanges. For each person it opens a unique prepared statement inside fb. Danny showed me the existence of the mon$statements table and it shows you 11481 equal insert statements. (then it crashes)
So or you forget to dispose the query somewhere, or you should reuse an existing query.
Submitted by: Alexander (sms-timing)
Relate to DNET852
Attachments:
Die.zip
I have an issue. It looks like something is not cleaned up in the code. Or even worse, something is not reused when it could be reused.
When we do a batch import of many persons over the EF firebird dies because of out of memory. (1.5 GB in 20 seconds)
What I do is making 20000 persons and then call SaveChanges. For each person it opens a unique prepared statement inside fb. Danny showed me the existence of the mon$statements table and it shows you 11481 equal insert statements. (then it crashes)
So or you forget to dispose the query somewhere, or you should reuse an existing query.
Commits: c02ccc7
The text was updated successfully, but these errors were encountered: