-come-first-served basis.
-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
The method I have found works well and efficiently is to surround your
Sqlite accesses with a semaphore and have accessing processes WAIT to
get access to Sqlite. For best performance you would only block when an
INSERT was in progress and let multiple SELECTs run concurrently.
This assumes
-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 Mald
.
>
> Fred
>
> > -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
> >
> >
>
gt; 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
>
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
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
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
You can't SELECT from your database while an INSERT has not finished.
SQLite will return the SQLITE_BUSY error if you try. You can't fix that.
It is not broken. In fact, it's necessary.
You can have your application simply loop with a delay, trying the SELECT
and waiting for the SQLITE_BUSY to
> I suspect that the tone of your messages and your insistence on getting
> some sort of unspecified help has irked more than a few members of this
> list.
I didn't think I could help without spanish.
I'm the guy who asked 'who is the bathroom' when I tried it last... ;)
"Cesar David Rodas Maldonado" <[EMAIL PROTECTED]> wrote:
> but is posible open several DATABASE with a programm and do transaccion
> without locked the table???
No. A transaction will always lock the database at some
point.
Regards
Cesar David Rodas Maldonado wrote:
please i need some help
Cesar,
I suspect that the tone of your messages and your insistence on getting
some sort of unspecified help has irked more than a few members of this
list.
I appreciate that English may not be your first language, but your
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
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
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
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
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,
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
>
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?
On 4/3/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 4/3/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
> I have a database that i do a lot of insert and select... really a lot
>
> but i have a problem with the lock database, couse when i do a lot of insert
> i can do a select
>
> i know that that is normal, but how can i fix it?,
20 matches
Mail list logo
