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