On Tue, Apr 5, 2011 at 4:05 PM, Technology Lighthouse <tlho...@gmail.com>wrote:
> Are there any hard or practical limits on the number of SQLite DBs that > can be held open at the same time? Not quite an answer your whole question, but possibly of interest... The OS environment determines how many file descriptor can be open at one time. If your OS runs out of file descriptor, it won't be able to open any more. Note that "file descriptor" does not just mean files, but also network connection (at the kernel level, sockets and files are, at least on Unix systems, basically the same thing). i have NO idea what the file handle limits are on non-Unix systems, but having, say, 200 dbs, each with 2(?) file handles (one for the journal and one for the db?), shouldn't be a problem on default Unix configurations (on some systems the limit can be raised if needed: google for "man 1 ulimit"). If some of your DBs spuriously cannot be opened then you are possibly running into the file descriptor limit and you may be forced to raise that limit (if possible) or start closing DBs which you do not currently need. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
