When to open and close the connection while using sqlite with singleton pattern

Question

I am developing an application for IPhone and using sqlite to connect to db. I am trying to use the singleton pattern for connecting to the db and retrieving the data.

I would like to know which is the best way to maintain the connection, should I keep the connection open till the application is closed or should I open and close the connection for every call that I make ?

Doug Currie · Accepted Answer · 2011-01-24 20:53:35Z

7

SQLite must re-parse the database schema each time a new connection is made. This can be time consuming. Leaving the connection open also provides opportunities for SQLite to cache data. Since you get ACID transactions even without closing the connection, there is little reason to close it. So, keep the SQLite connection open until the application is closed.

answered Jan 24, 2011 at 20:53

Doug Currie

41.4k1 gold badge104 silver badges121 bronze badges

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

Collectives™ on Stack Overflow

When to open and close the connection while using sqlite with singleton pattern

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related