>From http://www.hwaci.com/sw/sqlite/whentouse.html "Situations Where Another RDBMS May Work Better" * High Concurrency
SQLite uses reader/writer locks on the entire database file. That means if any process is reading from any part of the database, all other processes are prevented from writing any other part of the database. Similarly, if any one process is writing to the database, all other processes are prevented from reading any other part of the database. For many situations, this is not a problem. Each application does its database work quickly and moves on, and no lock lasts for more than a few dozen milliseconds. But there are some applications that require more concurrency, and those applications may need to seek a different solution. If you are really writing an app like Google, SQLite is quite possibly not the best solution because of its locking. -----Original Message----- From: Cesar David Rodas Maldonado [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 04, 2006 1:23 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] how to fix problem of lock Please people help me :D, the project will be open source... On 4/4/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > > OK English is not my first language, i am from south America, from > Paraguay so i speak Spanish... > > I am doing a project in C multiplataform.. right it project like > google, for a Linux. > > the project uses SQ Lite for repository. > > The software is a server which listen connection UDP. The server could > index (INSERT) and search within the database (SELECT). > > The problem is when i do so much connection at the same time for do > index and search at the same time. > > Know is it clear? sorry for my english :D > > Thanxs > > > > > On 4/3/06, John Stanton <[EMAIL PROTECTED]> wrote: > > > > Try to explain what you are doing. How do you access SQLITE? What > > language? What SQL are you using. How many concurrent users do you > > have? Are you getting a LOCK error because of multiple users? > > > > Cesar David Rodas Maldonado wrote: > > > please i need some help > > > On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > > > > > >>i insert numbers and select numbers, so what could be the > > >>solutions, couse i have to do that > > >> > > >> > > >>On 4/3/06, Pam Greene < [EMAIL PROTECTED] > wrote: > > >> > > >>>An INSERT can change the results of your SELECT, so the database > > >>>has > > to > > >>>be > > >>>locked during INSERT. Otherwise, the result of your SELECT would > > depend > > >>>on > > >>>whether the INSERT had finished yet. (The INSERT might even have > > only > > >>>partly finished, which would mean the SELECT was looking at a > > database > > >>>in an > > >>>inconsistent state.) It's not good to have unpredictable results > > like > > >>>that. > > >>> > > >>>For more explanation of why what you want isn't a good idea, see > > >>>any discussion of an "ACID" database, for example > > >>>http://en.wikipedia.org/wiki/ACID . > > >>> > > >>>- Pam > > >>> > > >>>On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: > > >>> > > >>>>HElp me, couse i just need to do insert and select, i dont use > > delete > > >>> > > >>>or > > >>> > > >>>>replate or update > > >>>> > > >>>>On 4/3/06, Cesar David Rodas Maldonado < [EMAIL PROTECTED] > wrote: > > >>>> > > >>>>>thanx man > > >>>>> > > >>>>> > > >>>>>but is posible open several DATABASE with a programm and do > > >>> > > >>>transaccion > > >>> > > >>>>>without locked the table??? > > >>>>> > > >>>>>On 4/3/06, Jay Sprenkle < [EMAIL PROTECTED]> wrote: > > >>>>> > > >>>>> > > >>>>>>On 4/3/06, Cesar David Rodas Maldonado < [EMAIL PROTECTED] > wrote: > > >>>>>> > > >>>>>>>I have a database.... ok... i do a lot of insert and select, > > >>>>>>>but > > >>> > > >>>>there > > >>>> > > >>>>>>is > > >>>>>> > > >>>>>>>sometime that i cant do the select couse the database is > > >>> > > >>>locked... > > >>> > > >>>>>>>i have to do a lot of insert every time, so how can i do for > > >>> > > >>>dont > > >>> > > >>>>lock > > >>>> > > >>>>>>the > > >>>>>> > > >>>>>>>database... > > >>>>>>> > > >>>>>>>understand guy? > > >>>>>> > > >>>>>>Try this: > > >>>>>>http://sqlite.org/lang_transaction.html > > >>>>>> > > >>>>> > > >>>>> > > >>>> > > >>> > > > > > > > > To find out more about Reuters visit www.about.reuters.com Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.
