Database Connection Lifetime
Rich Shepard <[email protected]>
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
In our approximate reasoning models data are stored in sqlite3 databases (one per model). Is it better to open a connection to the database when the model is opened (and close it when the model is closed) or open and close the connection each time data are to be written or retrieved from the database? Are there any standards or Best Programming Practices for this? Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc.(TM) | Accelerator <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863