Repository navigation
How long to open before close?
#323
|
Hello! I'm using Is it safe to never call |
Replies: 2 comments
|
Applications typically keep a database connection open for as long as it might be needed, which often is as long as the application itself is running. There is no intrinsic limit to the number of queries you can execute on a connection. Keep it open until you are done with it. If you are new to SQLite you may wish to read one or more books on how to use it. I understand that Using SQLite is particularly well-regarded in spite of its age (SQLite's obsession with backwards compatibility helps with that). |
Sure, but I get to decide when I'm done with it! Most of the time I'm not using it but it's still open in case a user clicks certain buttons... When using |
Applications typically keep a database connection open for as long as it might be needed, which often is as long as the application itself is running. There is no intrinsic limit to the number of queries you can execute on a connection. Keep it open until you are done with it.
If you are new to SQLite you may wish to read one or more books on how to use it. I understand that Using SQLite is particularly well-regarded in spite of its age (SQLite's obsession with backwards compatibility helps with that).