Hello, Is there a way to increase the number of attached databases beyond the default of 10 - from the command shell - by issueing a command / pragma?
I have 50+/- large tables (50GB - 100GB) and maintenance / transfer of them is much easier if each one is in its own SQLite DB file. I need to run SQL scripts that join groups of these tables. I was hoping to be able to create a "work" database - issue 50 attach staements - then refer to however many tables I need from the group using the DB.TABLE syntax. Is this reasonable? doable? I am trying to avoid bunching them together into 1/4 TB - 1 TB giant DBs. Thanks ! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
