Thank you, kind sir. Sometimes it is difficult to see the individual
ferns on the floor of the massive forest!
Oddly enough, the problem seems to have been caused by the lack of
the os.c file being compiled into the project at all? Some files that
were in the 3.2.8 code stream are no
Ken & Deb Allen <[EMAIL PROTECTED]> wrote:
>
> 1. I cannot locate in the 3.3.0 source code how the reference to
> sqlite3OsLock is converted into the virtual table method.
os.c line 61
> 2. There are no longer an os_win.h or os_unix.h file in the source
> tree, which is fine.
> 3. For some
For the life of me I cannot figure out where this is going wrong. I
am not a below average intelligence individual, and I have been
working with computers for over 30 years, but this one has me totally
at a loss.
I should point out that while I own MacOS based systems exclusively
for
This group is a wonderful resource. Some day I'll have enough
experience to contribute in a meaningful way...
I have a small number of read and writer threads. A few months ago I
had some deadlock issues and one simple solution was to run all
transactions as exclusive (ie BEGIN EXCLUSIVE).
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.
On Fri, 2006-01-13 at 08:12 -0800, [EMAIL PROTECTED] wrote:
>
> Hello,
>
> When I visit http://www.sqlite.org/support.html there is plenty of
> information about joining this list but nothing about how to unsubscribe.
>
> Anyone know how to do that?
>
> Thanks,
>
> Tom
>
This information
That information was given (in an email) when you subscribed:
To remove your address from the list, just send a message to
the address in the ``List-Unsubscribe'' header of any list
message. If you haven't changed addresses since subscribing,
you can also send a message to:
<[EMAIL PROTECTED]>
Looking around casually at various product's log files, including
Windows components, all my various apps. and any other software, I find
no examples of anyone employing other than "text" flat files for
"logging" purposes.
I suspect this is true because:
Text flat files are the simplest
Hello,
When I visit http://www.sqlite.org/support.html there is plenty of information
about joining this list but nothing about how to unsubscribe.
Anyone know how to do that?
Thanks,
Tom
> 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
> 2 - to easily manipulate log files to detect abnormal behaviour
You might want to check out Splunk - we don't run it here, but I've heard
good things about it - it may well be able to do what you're looking for.
www.splunk.com
Cheers,
David Carter-Hitchin.
--
Royal Bank of Scotland
Interest
Yes - although I executed each of those statements individually, e.g.:
Exec SQL1: begin tran
Exec SQL2: insert into...
Exec SQL3: commit tran (if rc good from SQL2) or "rollback tran" otherwise.
Cheers,
David Carter-Hitchin.
--
Royal Bank of Scotland
Interest Rate Derivatives IT
135
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
Hi To All
I am new to the list
In fact i had a logging system (to log errors and messages),
for my application using text file, but its very slow.
I tried SQlite, and its slower than the text file, is it normal??
I do the folowing :
//Creating the db file
int rc;
rc =
Rachel thank you for your reply
but your suggestion don't run for me,
I still to have the same terrible message:
"database disk image is malformed"
and I don't understand where is the problem,
thank you again
Andrea Federico.
--
___
Play 100s of
I don't know what caused this to happen but I've just had a similar problem.
Use .dump and .read to dump the table and restore it, and the problem
may go away (worked for me!)
Rachel
Hi all sqlite3 users,
I'm try to port sqlite version 3.3.0 on vxworks
I don't know why but using sqlite3 I receive
the same message error "database disk image is malformed"
if from shell I digit this commands:
sqlite> create table tbl1(one varchar(10), two smallint);
sqlite> insert into tbl1
Hi,
there is no link on the SQLite download page for "*Precompiled Binaries
For Windows" to download tclsqlite-3_3_0.zip (sqlitedll with TCL bindings).
Please can anyone provide the community / me with **tclsqlite-3_3_0.zip
as ** I have no access to a Microsoft OS/Compiler?
TIA
Stefan
*
21 matches
Mail list logo