[EMAIL PROTECTED] wrote:
Richard Nagle <[EMAIL PROTECTED]> wrote:
Need to create a test2.db
with following fields A B C
the data is mostly numerical, however it should be okay
with VARCHAR field? ( this is only a test of speed for importing and
searching )
Next Need to make Field "A" index able.
Then do a import of a text file sqtest.csv
into this new database.
What is the command for importing this in?
Whoever answers this question: please be sure to tell
Mr. Nagle about BEGIN...COMMIT. Otherwise he is going
to run his speed tests and think SQLite only does 25
inserts/second instead of 50,000 inserts/second.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Well its a little too late for that now, isn't it. :-)
But seriously, shouldn't the .import meta command in the sqlite shell do
this already?
Dennis Cote
