RE: [sqlite] Multi-User design

This really depends on many things. How often are the individual tables accessed and is the access spread evenly across them ? Also, what will there be a lot more reading than writing or will it be a close ratio ? We recently used sqlite in a multi-user environment using only a single database

RE: [sqlite] Performance Issue with SQLite Inserts

-Original Message- From: Soham Mehta [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 3:22 PM To: [EMAIL PROTECTED] Subject: [sqlite] Performance Issue with SQLite Inserts Hello, We recently switched to SQLite in our application and have not been able to get the performance

RE: [sqlite] Locking and concurrency

>Hi, >I am using sqlite 2.8.5 and I'd like to know if I can have a proces >that reads(select) while a proces is writing (insert or update) in the >same db. > >I have read FAQ number 7 but it doesn't help me. >Thank you very much. > >Bye Max >FAQ 7 >**Can multiple applications or multiple

RE: [sqlite] Solving the "busy" problem with many reads and a single write

>> Our tool to query the database is written in shell and invokes the >> sqlite command. Rather than re-write it in C to go through the API, I >> figured that I'd try changing the read locks to blocking in order to try >> to save time. Reads ONLY happen through this shell tool. Writes only >>