Re: [sqlite] make fails on Solaris

2005-07-19 Thread Christian Smith
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

Re: [sqlite] make fails on Solaris

2005-07-19 Thread Martin Jenkins
Christian Smith wrote: 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

[sqlite] How to store ' ?

2005-07-19 Thread Edwin Knoppert
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()

Re: [sqlite] How to store ' ?

2005-07-19 Thread Edwin Knoppert
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

[sqlite] Issue with Mac OS X and database file metadata (file size/disk free)

2005-07-19 Thread Aaron Burghardt
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

RE: [sqlite] Newbie Help Please

2005-07-19 Thread Wood, Lee
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

[sqlite] Efficient record insertion techniques?

2005-07-19 Thread R S
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

RE: [sqlite] Efficient record insertion techniques?

2005-07-19 Thread Griggs, Donald
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

Re: [sqlite] Efficient record insertion techniques?

2005-07-19 Thread R S
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

Re: [sqlite] Issue with Mac OS X and database file metadata (file size/disk free)

2005-07-19 Thread Doug Currie
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

RE: [sqlite] Efficient record insertion techniques?

2005-07-19 Thread Griggs, Donald
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

Re: [sqlite] Issue with Mac OS X and database file metadata (file size/disk free)

2005-07-19 Thread Aaron Burghardt
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

Re: [sqlite] Issue with Mac OS X and database file metadata (file size/disk free)

2005-07-19 Thread Aaron Burghardt
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

[sqlite] Question about temp table performance

2005-07-19 Thread K. Haley
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

[sqlite] How to truncate table?

2005-07-19 Thread chan wilson
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:

Re: [sqlite] How to truncate table?

2005-07-19 Thread Puneet Kishor
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'

Re: [sqlite] How to truncate table?

2005-07-19 Thread chan wilson
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

Re: [sqlite] How to truncate table?

2005-07-19 Thread Puneet Kishor
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>

Re: [sqlite] How to truncate table?

2005-07-19 Thread chan wilson
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: