On Fri, 15 Jul 2005, Dan Kennedy wrote:
>See if your installation has "nawk" or "gawk". Then search through
>Makefile.in and change the "awk" invocations to "nawk" or "gawk"
>(three changes). It might work then.
Solaris /usr/bin/awk is horrible and not nawk compatible.
>
>
>--- H S <[EMAIL
If i read correct BLOB data can now handle chr(0) as well.
But another issue i solved with access is the embedding of ' characters.
I'm using single quotes for field data during INSERT.
How can a field contain single quotes for data?
Access allows to use BASIC code and let's you insert + Chr()
Gosh, sorry, just re-read the faq:
INSERT INTO xyz VALUES('5 O''clock');
- Original Message -
From: "Edwin Knoppert" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, July 19, 2005 1:49 PM
Subject: [sqlite] How to store ' ?
If i read correct BLOB data can now handle
Hello,
We are inserting records into SQLite databases, and in our testing
have discovered that in some circumstances it is possible to be
inserting records inside a transaction, yet not have the fact that
the database journal file is growing be reflected accurately by the
file system. In
Dennis and Tim-
TY VM! VM! VM! VM!
I was about to use MySQL because I was too stupid to figure this out!
TY VM
Lee
-Original Message-
From: Tim McDaniel [mailto:[EMAIL PROTECTED]
Sent: Mon 7/18/2005 1:48 PM
To: sqlite-users@sqlite.org
Hi,
I wrote a Real Time logging app that insert logs from various Unix
machines in our lab into a sqlite Database.
The insertions are not batched as of now. Maybe that itself is an optimization.
1) Should I use a transaction even for a single record?
2) I open the DB, insert the record and close
I'm no expert, but I hope the following are accurate.
Regarding: 1) Should I use a transaction even for a single record?
You already are, since your inserts automatically become one-line
transactions.
Re: 2) I open the DB, insert the record and close the DB for every record
inserted. What if
Thanks Donald. Inline
On 7/19/05, Griggs, Donald <[EMAIL PROTECTED]> wrote:
> I'm no expert, but I hope the following are accurate.
>
> Regarding: 1) Should I use a transaction even for a single record?
> You already are, since your inserts automatically become one-line
> transactions.
OK
Tuesday, July 19, 2005, 12:19:48 PM, Aaron wrote:
> We are inserting records into SQLite databases, and in our testing
> have discovered that in some circumstances it is possible to be
> inserting records inside a transaction, yet not have the fact that
> the database journal file is growing
Regarding inserting log records to sqlite database:
Re: OK then I guess I need to batch them to improve performance. Temp tables
best way to go?
Yes, if, after leaving the database open, you still need more
performance improvement, then batching multiple inserts per transaction
should help
On Jul 19, 2005, at 4:21 PM, Doug Currie wrote:
[...] If I have exceeded the amount of free space,
though, attempting to commit the transaction will fail.
That is also as expected. SQLite will cache modified pages in RAM, and
attempt to write them to disk at commit time.
OK, that's
On Jul 19, 2005, at 7:50 PM, Aaron Burghardt wrote:
On Jul 19, 2005, at 4:21 PM, Doug Currie wrote:
[...] If I have exceeded the amount of free space,
though, attempting to commit the transaction will fail.
That is also as expected. SQLite will cache modified pages in RAM,
and
attempt
I have two versions of the same algorithm. The first operates directly
on the main db table. The second operates on a temp table containing
only the working set. The problem is that the second version is about
20x slower, 1.5 sec versus 30 sec. If the EXISTS line in the second
version is
Hi,
In MS SQL, there is a "TRUNCATE TABLE" SQL that will remove all the
records of a table and make the identity back to zero.
Is there any means to accomplish it in sqlite?
Thanks!
_
与世界各地的朋友进行交流,免费下载 MSN Messenger:
On Jul 19, 2005, at 11:50 PM, chan wilson wrote:
Hi,
In MS SQL, there is a "TRUNCATE TABLE" SQL that will remove all the
records of a table and make the identity back to zero.
Is there any means to accomplish it in sqlite?
How about
DELETE FROM table;
I am assuming, by 'identity'
Hi Puneet Kishor ,
Yes, you are right. I have to check out whether "DELETE FROM table;" will
really set the auto imcrement primary key seed back zero.
From: Puneet Kishor <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How to truncate
On Jul 20, 2005, at 12:33 AM, chan wilson wrote:
Hi Puneet Kishor ,
Yes, you are right. I have to check out whether "DELETE FROM table;"
will really set the auto imcrement primary key seed back zero.
Yes, it will. Here you go --
sqlite> create table t (a integer primary key, b);
sqlite>
Dear Puneet Kishor,
I never thought it does since I checked out the documentation of sqlite,
it does not mention it.
Greatly thanks for you very kind help!
Cheers!
Yours,
Wilson Chan
From: Puneet Kishor <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To:
18 matches
Mail list logo