Re: [sqlite] basic insert questions...

2008-10-15 Thread David Clark
At 03:01 PM 10/15/2008, Jay A. Kreibich wrote: >On Wed, Oct 15, 2008 at 01:38:16PM -0500, David Clark scratched on the wall: > > Ok I want to convert a large application which uses ad-hoc data > > structures and file formats to a sqlite database. But before I do that > > I am working on a proof of

Re: [sqlite] basic insert questions...

2008-10-15 Thread Doug
ke it bold? Doug > -Original Message- > From: [EMAIL PROTECTED] [mailto:sqlite-users- > [EMAIL PROTECTED] On Behalf Of D. Richard Hipp > Sent: Wednesday, October 15, 2008 3:16 PM > To: [EMAIL PROTECTED]; General Discussion of SQLite Database > Subject: Re: [sqlite]

Re: [sqlite] basic insert questions...

2008-10-15 Thread D. Richard Hipp
On Oct 15, 2008, at 4:01 PM, Jay A. Kreibich wrote: > > Issue the command "BEGIN", do 100 to 1 INSERTs, issue a "COMMIT". > You should see a very noticeable difference in speed. >> Just to amplify Jay's words: On a workstation, SQLite should do at least 50,000 INSERTs per second. But due

Re: [sqlite] basic insert questions...

2008-10-15 Thread Jay A. Kreibich
On Wed, Oct 15, 2008 at 01:38:16PM -0500, David Clark scratched on the wall: > Ok I want to convert a large application which uses ad-hoc data > structures and file formats to a sqlite database. But before I do that > I am working on a proof of concept test to show that yea it will work > once c

[sqlite] basic insert questions...

2008-10-15 Thread David Clark
Ok I want to convert a large application which uses ad-hoc data structures and file formats to a sqlite database. But before I do that I am working on a proof of concept test to show that yea it will work once conversion is done. But alas my first test is failing miserably. Well, it works it j