Woah,
Stop in time,
what this command? how does one add this?
I want to see the real state of sqlite, at its max speed.
Regards to all.
Richard Nagle
Dennis Cote wrote:
[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
--
I will not be pushed, filed, stamped,
indexed, briefed, debriefed, or numbered!
My life is my own - No. 7
