Re: [sqlite] PATCH: compound (multi-row) INSERT statements

2007-10-24 Thread Ken
I see now, thanks for the clarification. Sorry for the ramblings. And there is a .mode csv so that should take care of data loading. Regards, Ken Joe Wilson <[EMAIL PROTECTED]> wrote: --- Ken wrote: >A new command ".imp" command could be made to use my proposed array based > processing.

Re: [sqlite] PATCH: compound (multi-row) INSERT statements

2007-10-23 Thread Ken
Same problem, just a different thought process. The .dump format could me made to use a CSV making it more compact. A new command ".imp" command could be made to use my proposed array based processing. And also use DRH's recommendation to use a TXN Unfortunately, .dump is generic for

Re: [sqlite] PATCH: compound (multi-row) INSERT statements

2007-10-23 Thread Joe Wilson
You're solving a different problem. Better to stick with the existing API for what you're proposing. I just want a faster, more compact and flexible SQL INSERT command from the command-line without resorting to custom programming. --- Ken <[EMAIL PROTECTED]> wrote: > Joe, > > that is quite

Re: [sqlite] PATCH: compound (multi-row) INSERT statements

2007-10-23 Thread Joe Wilson
--- [EMAIL PROTECTED] wrote: > Joe Wilson <[EMAIL PROTECTED]> wrote: > > FYI: When this multi-row-insert patch is combined with today's CVS > > OP_Real and OP_Int64 fix for Tickets #2733 and #2731 (Check-in [4507]), > > the multi-row ASCII INSERT statements are as much as 25% faster than > >

Re: [sqlite] PATCH: compound (multi-row) INSERT statements

2007-10-23 Thread drh
Joe Wilson <[EMAIL PROTECTED]> wrote: > FYI: When this multi-row-insert patch is combined with today's CVS > OP_Real and OP_Int64 fix for Tickets #2733 and #2731 (Check-in [4507]), > the multi-row ASCII INSERT statements are as much as 25% faster than > the equivalent number of traditional

Re: [sqlite] PATCH: compound (multi-row) INSERT statements

2007-10-23 Thread Ken
Joe, that is quite interesting performance gain... One thing that might help with this "multi row" insert is the concept of binding address variables. IMHO, the binding functions (sqlite_bind_int etc) should allow one to permanently bind an address to a placeholder. Then you multi row insert

Re: [sqlite] PATCH: compound (multi-row) INSERT statements

2007-10-23 Thread Joe Wilson
FYI: When this multi-row-insert patch is combined with today's CVS OP_Real and OP_Int64 fix for Tickets #2733 and #2731 (Check-in [4507]), the multi-row ASCII INSERT statements are as much as 25% faster than the equivalent number of traditional individual ASCII INSERT statements within a

[sqlite] PATCH: compound (multi-row) INSERT statements

2007-10-14 Thread Joe Wilson
The attached patch implements the compound (multi-row) INSERT statement syntax against the SQLite 3.5.1 source tree. Both named and unnamed INSERT column syntax with DEFAULT column values are supported. The patch transforms multi-row INSERT statements into compound SELECT statements separated by