SQLite Open Close - how often?

sloopa · #1 (**permalink**) 04-30-2007, 06:44 PM

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?

sloopa

Erel · #2 (**permalink**) 04-30-2007, 07:29 PM

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

sloopa · #3 (**permalink**) 05-01-2007, 02:46 PM

My database is on the device.

Erel · #4 (**permalink**) 05-01-2007, 03:01 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tippy v.1.0 [open source]	N1c0_ds	Share Your Creations	3	09-20-2008 02:51 PM
file open question	scott93727	Questions & Help Needed	4	05-30-2008 10:07 AM
Serial Port won't open	djmrozinski	Questions & Help Needed	6	03-16-2008 05:25 PM
Is it possible to open a JPEG and resize?	tigme	Questions & Help Needed	5	02-19-2008 09:19 PM
Problem with B4P and SQLite after close the application	Fontanus	Questions & Help Needed	4	08-10-2007 10:16 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)