It looks as if the sys admin installed the libray with sqite 3 and perls
DBD::Sqlite but used the Sqlite bin version instead of Sqlite 3.whatever for
manipulating it from the shell.
I'll ask him to install the sqlite3 bin files and see if it fixes itself.
However it really does work every once
I am currently using SQLite to process @ 400 million records (and climbing)
a day by reading files, importing them into SQLite, and summarizing. The
summed data goes into Oracle. This is a production application that is very
stable. Holding the data in SQLite in memory as opposed to a C struct
I recently reported a similar error. After
upgrading to sqlite3, I noticed that I would
occassionally get the "database disk image is
malformed" errors using the library code. I just
closed/reopened the db, retried the query and always
had success on the retry. No idea why - D. Richard
Hipp s
Hello,
Just wondering why I get this error when trying to open the DB with the Binary
interface. It has actually worked on the odd occasion.
sqlite l_main.dbl
Unable to open database "l_main.dbl": database disk image is malformed
Regards,
Leander
> My company is starting a project in wich we will have to process
> large amounts of data and save the results to a db2 database.
> Because this data process needs to be very fast, the idea is to load
> the data in memory and apply the transformations in C++. I think that
> sqlite inmemory datab
On Tue, 28 Jun 2005, Rasmus Christian Kaae wrote:
>If you are running Windows you may use a similar memory-mapped file (see the
>Win32API for details).
>
>
>Does anyone know which is fastest -- Using a memory-mapped file (or
>/dev/shm) in comparison with sqlite's internal memory mapped tree?
Hav
Yaa
You are right; I solved the problem by using some of synchronization objects
for thread access. Thanks for giving me direction.
-Original Message-
From: Will Leshner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 28, 2005 7:07 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Error
On Jun 28, 2005, at 5:08 AM, Ajay wrote:
I am trying to insert values into table and executing that query from
thread. There are 2 more threads that accesses same table.
Do all the threads use the same sqlite handle? I believe that can
cause problems.
Sorry for wrong query!
I am trying to insert values into table and executing that query from
thread. There are 2 more threads that accesses same table.
Correct query is
Insert table SOURCEFEED (SOURCEFEED, STATUS) values ("ABC",0)
Let me know what could be reason behind this
-Original M
> I am facing one weird problem using SQLite. Many times I get an error
> "Library routine called out of sequence" while executing query "Create table
> SOURCEFEED (SOURCEFEED,STATUS) values ( "ABC",0)" , I'm not getting the
> reason behind this. Why am I getting this error? My application is a
> m
Hello there,
I am facing one weird problem using SQLite. Many times I get an error
"Library routine called out of sequence" while executing query "Create table
SOURCEFEED (SOURCEFEED,STATUS) values ( "ABC",0)" , I'm not getting the
reason behind this. Why am I getting this error? My application is
If you are running Windows you may use a similar memory-mapped file (see the
Win32API for details).
Does anyone know which is fastest -- Using a memory-mapped file (or /dev/shm) in
comparison with sqlite's internal memory mapped tree?
--
Best regards / Med venlig hilsen
Rasmus Christian Kaae - [
If you are using Linux, you can use the /dev/shm. This is a memory
resident file system. I use this and find it about 200 times faster
than writing to disk. The only problem is that this is erased when the
server reboots. I hope this is of some use :)
Ben
Lorenzo Jorquera wrote:
Hi,
My
13 matches
Mail list logo