There's a discussion on another forum I'm on about whether it's good practice to open an SQLite database as part of program initialization and close it when the program terminates, or whether the connection should be opened and closed around each transaction.
I've always used the first approach and can't think of any benefits to the second unless you're simply reading data into memory and never accessing the database directly again. Are there any other circumstances where the second approach is better? Pete _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
