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 > >>>>>> > >>>>> > >>>>> > >>>> > >>> > > > >