EF firebird dies because of out of memory
-----------------------------------------

                 Key: DNET-274
                 URL: http://tracker.firebirdsql.org/browse/DNET-274
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, Entity Framework support
    Affects Versions: 2.5.1, 2.5.0
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura


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.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to