When to close a SQLite database (using FMDB)

Question

When should you close the connection to the SQLite database (using [db close] in FMDB)?

Now I close it after starting each batch of related requests, but should I close when my application closes? What are the pros and cons anyway?

thanks

+6

Souleiman Mar 30 '13 at 15:35

1 answer

ccgus · Accepted Answer · 2013-03-30T20:09:19+0000

I am the guy who wrote FMDB.

Keep it open unless you change your layout. The only reason it closes and constantly reopens is to hit performance / battery life a bit.