Re: [sqlite] Need to do a Test.

2005-09-30 Thread Richard Nagle
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

Re: [sqlite] Need to do a Test.

2005-09-30 Thread Dennis Cote
On 9/30/05, Dennis Cote <[EMAIL PROTECTED]> wrote: > > > But seriously, shouldn't the .import meta command in the sqlite shell do > this already? Sorry for the self reply, but I just checked the source, the .import command does do a BEGIN and COMMIT around the insert statements it executes. So Ri

Re: [sqlite] Need to do a Test.

2005-09-30 Thread Dennis Cote
[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" inde

Re: [sqlite] Need to do a Test.

2005-09-30 Thread Dennis Cote
Richard Nagle 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.cs

Re: [sqlite] Need to do a Test.

2005-09-30 Thread drh
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