Fitzpatrick, Bill (MS) wrote:
We are considering SQLite to manage our data which is distributed over
a number of ordinary directories (about a 1000 and growing).
Is it feasible to create a separate SQLite database for each directory,
totaling more than a 1000
databases each managed by the same SQLite server? What is the maximum number
of databases
managed a single server?
http://www.sqlite.org/
"About SQLite
SQLite is a small C library that implements a self-contained,
embeddable, zero-configuration SQL database engine...."
Note: it says *engine* not server.
SQLite is not a DBMS in the true sense, it is a library that you link to
your applications that allows you to manage tables of a database in one
file. You can open as many database files as your environment will allow..
--
Craig Morrison
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
http://pse.2cah.com
Controlling pseudoephedrine purchases.
http://www.mtsprofessional.com/
A Win32 email server that works for You.
