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]>
