[sqlite] SQLite Optimization

I am trying to optimize the speed of my SQLite transactions. The goal is to beat query and insertion times that we have with MS SQL. I guess there are 2 main issues: 1) The query times are faster when I do simple select statements on a large amount of data. I start to run into trouble when I get

[sqlite] Location of Sqlite Files

Hey, I am kind of new to SQLite. I was wondering if anyone could help me with a couple things: 1) Where are the SQLite databases stored? I was told in the C:\WINDOWS\temp folder, but I can't seem to find any SQLite-related files there. 2) How do you delete a SQLite database? Any help is much appr