Out of memory in SQLite using nhibernate

Question

I wish to know if there is way to evict/clear the session even thogh Im using SQLite.

I have a lot of data that i want to save, and commit all in one transaction. I use session.flush() and then session.evict() after every save, but the ram still raise and there is overflow.

Any ideas ? Thanks a lot.

Neel · Accepted Answer · 2015-01-29 12:21:28Z

0

You require Session.Clear() before Session.Abandon because of following reason

Session.Clear() will CLEAR the values of all the keys but will NOT cause the session end event to fire.

Session.Abandon() will NOT clear the values on the current request. IF another page is requested, the values will be gone for that one. However, abandon WILL throw the event.

It would be better to use Session.Clear() rather than using Session.Abandon() because the values still exist in session after calling Session.Abandon() but are removed after calling the Session.Clear() .

answered Jan 29, 2015 at 12:21

Neel

11.7k3 gold badges46 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Or Cohen Over a year ago

Im not using asp, the session is an isession object so i do not have abandon function. Im also do need to erase everything from the session to prevent the memory ezxception.

Neel Over a year ago

will it help? stackoverflow.com/questions/189280/… @OrCohen

Or Cohen Over a year ago

How this article can help me exectly ?

Dmitry S. · Accepted Answer · 2015-01-30 18:12:14Z

0

You should be using IStatelessSession when inserting a large number of records.

answered Jan 30, 2015 at 18:12

Dmitry S.

8,5532 gold badges41 silver badges53 bronze badges

Collectives™ on Stack Overflow

Out of memory in SQLite using nhibernate

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related