I'm also curious, now that someone asked.
If there is no limit, it is easy to just «mmap» a text file and let sqlite
handle it (offcourse a few checks would be necessary).
Not that it's a much wanted feature, just a «cool» thing to do with sqlite ;)
Regards,
~Nuno Lucas
=== On 2004-06-15, Shawn
Is there a reason you don't want to use a begin transaction, then insert
everything, then end the transaction? It is extremely efficient to do this.
Shawn
-Original Message-
From: Xuer [mailto:[EMAIL PROTECTED]
Sent: Monday, June 14, 2004 11:56 PM
To: [EMAIL PROTECTED]
Subject: [sqlite
could i use a long,long sql sentence to insert many items into a table
once without limit?
or there IS a limit so i have to accomplish it by doing it for multi times?
thanks in advance.:)
-
To unsubscribe, e-mail: [EMAIL PROTECT
In my database, I am going to be inserting many rows at a time. There
might be duplicate rows in the database which I would not know the
primary key for. There are several databases on several computers
merging into one database which the first ones only occasionally
contact. The schema so far
Keith Herold wrote:
The current cleaned-up source download is not 2.8.14, but I would like to
use 2.8.14 in an upcoming product. Does anyone have the perl code handy
(and willing to give it to me :) ) that I could use to clean up the source
code (it's for windows; I can do it myself, but it will t
The current cleaned-up source download is not 2.8.14, but I would like to
use 2.8.14 in an upcoming product. Does anyone have the perl code handy
(and willing to give it to me :) ) that I could use to clean up the source
code (it's for windows; I can do it myself, but it will take me a while, so
I
Wempa, Kristofer (Kris), ALABS wrote:
Our tool to query the database is written in shell and invokes the
sqlite command. Rather than re-write it in C to go through the API, I
figured that I'd try changing the read locks to blocking in order to try
to save time. Reads ONLY happen through this shel
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent: Monday, June 14, 2004 10:51 AM
Cc: [EMAIL PROTECTED]
Subject: Re: [sqlite] Solving the "busy" problem with many reads and a
single write
Wempa, Kristofer (Kris), ALABS wrote:
> I'm new to this list and I didn't see
Wempa, Kristofer (Kris), ALABS wrote:
> I'm new to this list and I didn't see this question answered in the places I
> looked. We have a system that uses a handful of commands to read and write
> to an SQLITE database. We already control the commands so that only 1 thread
> in one process writes
Richard Boehme wrote:
Hi there. I'm thinking of putting some data into two separate databases
(user info and tracking info). However, if I did that, I would need to
do some SELECT statements across both databases (select with two tables
with a common identifier in both tables; the tables are in
I'm new to this list and I didn't see this question answered in the places I looked.
We have a system that uses a handful of commands to read and write to an SQLITE
database. We already control the commands so that only 1 thread in one process writes
to the database file at any point in time.
On 6/14/2004 4:05 PM, Richard Boehme wrote:
Hi there. I'm thinking of putting some data into two separate databases
(user info and tracking info).
>
Why ? Strande solution ;-)
It user info and tracking info are related entities, why
you want to store it separately ?
Is this possible with SQLite?
> > Is there a way I could use LIMIT in an update?
>
> No, but if your table has a single-column primary key,
> called PK for example, you can get the same result with
>
> update Address set Retrieved = 1
> where PK in (select PK from Address
>where Group = 'a' limit 5)
Would y
Hi there. I'm thinking of putting some data into two separate databases
(user info and tracking info). However, if I did that, I would need to
do some SELECT statements across both databases (select with two tables
with a common identifier in both tables; the tables are in two separate
database
14 matches
Mail list logo