Re: [sqlite] Speeding up index creation?

2008-05-23 Thread Nemanja Čorlija
On Fri, May 23, 2008 at 4:20 PM, Stefan Arentz <[EMAIL PROTECTED]> wrote: > I have an interesting problem. I need to generate a large table > periodically. The table contains a unique SHA1 hash code and 6 integer > values and has about 6 million rows. Generating this table is fast. I > can set it u

Re: [sqlite] Speeding up index creation?

2008-05-23 Thread Jay A. Kreibich
On Fri, May 23, 2008 at 10:20:45AM -0400, Stefan Arentz scratched on the wall: > I have an interesting problem. I need to generate a large table > periodically. The table contains a unique SHA1 hash code and 6 integer > values and has about 6 million rows. Generating this table is fast. I > can set

Re: [sqlite] schema optimization question

2008-05-23 Thread Stephen Oberholtzer
On Fri, May 23, 2008 at 3:01 PM, Jeff Gibson <[EMAIL PROTECTED]> wrote: > I'm sorry if this is an obvious question - I'm new to databases. I have > an application where the database is used to log a large number of > simulation events. The database is written once and read many times > (i.e., th

Re: [sqlite] schema optimization question

2008-05-23 Thread Keith Goodman
On Fri, May 23, 2008 at 12:01 PM, Jeff Gibson <[EMAIL PROTECTED]> wrote: > I'm sorry if this is an obvious question - I'm new to databases. I have > an application where the database is used to log a large number of > simulation events. The database is written once and read many times > (i.e., th

Re: [sqlite] Autocommit .read inserts are so slow it must be a bug

2008-05-23 Thread Kees Nuyt
On Fri, 23 May 2008 15:21:42 + (GMT), Morten wrote: > Hi > > I've been puzzled for some days. I believed I had a > hang in my system, but it turns out using the .read > is horribly slow. I believed it to be an > improper trigger, but removing it doesn't help a bit. > 1min36sec to read 1000 l

[sqlite] schema optimization question

2008-05-23 Thread Jeff Gibson
I'm sorry if this is an obvious question - I'm new to databases. I have an application where the database is used to log a large number of simulation events. The database is written once and read many times (i.e., there are never any inserts or updates after database creation). The three mos

Re: [sqlite] Why is SQLite so slow across a network (afp Mac OS X)?

2008-05-23 Thread Peter K. Stys
On Fri, May 23, 2008 at 4:31 AM, Christian Smith < [EMAIL PROTECTED]> wrote: > On Tue, May 13, 2008 at 11:15:51PM -0600, Peter K. Stys wrote: > > Hi Folks: > > I'm new to this list and just came across a major issue so I thought I'd > > post here: I'm using SQLite (from REALbasic which uses the SQ

[sqlite] Autocommit .read inserts are so slow it must be a bug

2008-05-23 Thread morten bjoernsvik
Hi I've been puzzled for some days. I believed I had a hang in my system, but it turns out using the .read is horribly slow. I believed it to be an improper trigger, but removing it doesn't help a bit. 1min36sec to read 1000 lines with 6 simple columns into one table. I know insert w

Re: [sqlite] baffling performance decrease across network (specific case)

2008-05-23 Thread Serena Lien
Thank you, that was immensely helpful - as well as Roger Binns many informative posts about OpLocks. Looks like there is nothing to be done about the slowdown (in fact I should be grateful there is even such a thing as opportunistic locking to make the single client situation faster), but it is a

[sqlite] Speeding up index creation?

2008-05-23 Thread Stefan Arentz
I have an interesting problem. I need to generate a large table periodically. The table contains a unique SHA1 hash code and 6 integer values and has about 6 million rows. Generating this table is fast. I can set it up in less than 90 seconds on a slow iMac (2.16 Ghz and slow disk). The thing that

Re: [sqlite] Moving Backwards in SQLite

2008-05-23 Thread Jay A. Kreibich
On Fri, May 23, 2008 at 12:13:39AM -0700, Roger Binns scratched on the wall: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > sqlite wrote: > > our workaround to move backwards is optimistic. if some one could help me in > > this regard, if could share some code for moving backwards it would

Re: [sqlite] Why is SQLite so slow across a network (afp Mac OS X)?

2008-05-23 Thread Christian Smith
On Tue, May 13, 2008 at 11:15:51PM -0600, Peter K. Stys wrote: > Hi Folks: > I'm new to this list and just came across a major issue so I thought I'd > post here: I'm using SQLite (from REALbasic which uses the SQLite DB engine > for SQL support) to store image files, and while R/W to local files i

Re: [sqlite] Equivalent of mysql_real_escape_string() ?

2008-05-23 Thread Eugene Wee
Hi all, Scott Baker wrote: > As mentioned above the BEST way to do it is with prepared statement > and bound variables. If you have to use raw SQL then just use the > PDO::quote method: > > http://php.web-ster.com/manual/en/pdo.quote.php > > $conn = new PDO('sqlite:/home/lynn/music.sql3'); $stri

Re: [sqlite] Moving Backwards in SQLite

2008-05-23 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sqlite wrote: > our workaround to move backwards is optimistic. if some one could help me in > this regard, if could share some code for moving backwards it would be more > helpful to me. http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor Roger ---

[sqlite] Moving Backwards in SQLite

2008-05-23 Thread sqlite
Dear All, i have developed an application using SQLite which runs in the pocket pc device. My application has to show some messages in a list box (custom build) while moving forward im able to move the records one by one in the recordset. But when i move upwards im not able to move to the corresp