Re: [sqlite] SQLite -- Very Slow -- ??

2006-01-13 Thread Miguel Angel Latorre Díaz
I usually create a worker thread to send log lines through UDP to a syslog. UDP is damm fast and you do not have to wait.

RE: [sqlite] SQLite -- Very Slow -- ??

2006-01-13 Thread Fred Williams
Sent: Friday, January 13, 2006 9:47 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQLite -- Very Slow -- ?? > > > > Hi > > > > <> > > When I run the program without logs an action take 1ms, > with logs inserted > > in a text file it takes 1.2m

Re: [sqlite] SQLite -- Very Slow -- ??

2006-01-13 Thread Jay Sprenkle
> Hi > > <> > When I run the program without logs an action take 1ms, with logs inserted > in a text file it takes 1.2ms so its "SLOW", and with logs inserted in a > SQLite DB it takes 1.4ms so its "SLOWER" than the text file. Not to be negative or anything, but you're asking the computer to do

Re: [sqlite] SQLite -- Very Slow -- ??

2006-01-13 Thread khaldoun kassem
Thank you Ran After Testing SQLite, I guessed that the "wite to file" is the fastest way to save information to disk. I can't use transactions because the aim of the logs is that if my shutdown incorrectly I can know where is the problem, if I use transactions I'll loose last actions and may be

RE: [sqlite] SQLite -- Very Slow -- ??

2006-01-13 Thread CARTER-HITCHIN, David, FM
est Rate Derivatives IT 135 Bishopsgate LONDON EC2M 3TP Tel: +44 (0) 207 085 1088 > -Original Message- > From: khaldoun kassem [mailto:[EMAIL PROTECTED] > Sent: 13 January 2006 11:42 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQLite -- Very Slow -- ?? > >

RE: [sqlite] SQLite -- Very Slow -- ??

2006-01-13 Thread CARTER-HITCHIN, David, FM
ves IT 135 Bishopsgate LONDON EC2M 3TP Tel: +44 (0) 207 085 1088 > -Original Message- > From: Manfred Bergmann [mailto:[EMAIL PROTECTED] > Sent: 13 January 2006 11:28 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] SQLite -- Very Slow -- ?? > > > What do you m

Re: [sqlite] SQLite -- Very Slow -- ??

2006-01-13 Thread khaldoun kassem
Hi <> When I run the program without logs an action take 1ms, with logs inserted in a text file it takes 1.2ms so its "SLOW", and with logs inserted in a SQLite DB it takes 1.4ms so its "SLOWER" than the text file. <> I Try tu use database for 2 reasons : 1 - because the text file logs was

Re: [sqlite] SQLite -- Very Slow -- ??

2006-01-13 Thread Manfred Bergmann
What do you mean by wrapping into a transaction? Doing something like this? : BEGIN TRANSACTION; exec Sql-Statement COMMIT TRANSACTION; regards, Manfred Bergmann Am 13.01.2006 um 22:15 schrieb CARTER-HITCHIN, David, FM: I had similar issues with inserts and solved them by wrapping the

RE: [sqlite] SQLite -- Very Slow -- ??

2006-01-13 Thread CARTER-HITCHIN, David, FM
I had similar issues with inserts and solved them by wrapping the insert into a transaction. Regards, David Carter-Hitchin. -- Royal Bank of Scotland Interest Rate Derivatives IT 135 Bishopsgate LONDON EC2M 3TP Tel: +44 (0) 207 085 1088 > -Original Message- > From: khaldoun kassem