Hello all,
 
I'm working on a GUI application using Tcl/Tk with sqlite back end on windows. 
Now, multiple users will be running this and all users must have a copy of the 
db local to their PC or in a shared drive. At least that is my understanding of 
how sqlite works.
 
1. What are my options if the db gets very large (say > 1 G) and we don't want 
users to allocate that much disk space and RAM?
 
2. How does sqlite allocate RAM when doing select statements? what about when 
opening the db ?
 
3. Are there any ways to compress db files in disk (for free) and then is 
sqlite able to still get to the data easily?
 
Thank you!


      
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to