SQLite Open Close - how often?

[sloopa]

What is your opinion -
Open the database one time and by closing the application close the database too

or

every query open and close the database?

:sign0085:

sloopa

 

[Erel]

Where is your database located (on the device, on a network drive...)?

 

[sloopa]

My database is on the device.

 

[Erel]

Then you should open it at the beginning and close it at the end.