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.
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
> 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
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
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 -- ??
>
>
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
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
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
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
9 matches
Mail list logo