Re: [sqlite] import / insert 120k records

2009-05-07 Thread Alexander A. Gnatyna
On Thursday 07 May 2009 15:42:52 Ben Marchbanks wrote: > Whats the best way to import a large number of records ? > 120K+ currently stored as an XML file. Parse XML with perl using for example XML::Twig and insert into database( with transactions of course). _

Re: [sqlite] Names of Indexes (CREATE INDEX)

2009-05-01 Thread Alexander A. Gnatyna
you can name indexes as you wish. if you use select - you should specify coluns names. engine well decide what index to use depend on CREATE INDEX statement and you SQL query. On Saturday 02 May 2009 02:45:03 a a wrote: > Do index names need to be different from field names? > When doing selec