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.
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
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
--- [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
> >
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
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
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
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
8 matches
Mail list logo