Hi, I can't seem to find information about creating precompiled statements when using the commandline program to access the sqlite database. What i'm doing at the moment is using a C# program to generate text files of insert statements up to 100megs in size and then using .read to import them. Each insert statement is identical except for the values that are being imported, so in this scenario if i could use precompiled SQL, it would result in quite a benefit, but i can't seem to be able to do this.
Thanks, Alan.