[sqlite] Odd indexing behavior, 2nd request for help

Hello. I sent this 2 days a go but have not received an explanation or solution. Anybody had this problem? Hello and Happy New year! I have an indexing problem with a very simple query. The correct index is not used or no index is used, according to Explain Query Plan. In the following query,

Re: [sqlite] odd indexing behavior

Thanks for the response, Joe. Unfortunately, since I have no way of knowing a priori what the relative number of returned rows is (without doing another query), using the plus is not really a work-around, it is a "don't use indexes" rule. I can't just arbitrarily assign the "plus" mark. Also, no

[sqlite] odd indexing behavior

Hello and Happy New year! I have an indexing problem with a very simple query. The correct index is not used or no index is used, according to Explain Query Plan. In the following query, all columns but num have indexes, using default. num is integer; filetype is Varchar; time1 is Datetime; name

[sqlite] Way to "Bind" Columns in Prepare

Of course. Thanks.

[sqlite] Way to "Bind" Columns in Prepare

I need to embed variable column names in my queries, such as 'colX > '2004-01-01' where 'X' is a variable. bind_text will not do this. Is there another way? Thanks. Michael

RE: [sqlite] SQLiteSpy vs. SQLite.dll speed comparison

Thanks to Christian and John for the pointers regarding compilers. I have not compiled the sqlite sources myself but have used the supplied binary. Could either one you give me some tips for compiling the sqlite sources for either vs 6 or 8? John, I will follow your advice on inline functions.

RE: [sqlite] SQLiteSpy vs. SQLite.dll speed comparison

Daniel: Thanks for the suggestion. I wasn't aware that the prepare statement gained you that much for one-table select queries. I use it for multi-100k inserts (along with trans.) and it saves quite a bit of time. This is my sql for the present problem: select * from (select f1, f2, f3, f4, f5

RE: [sqlite] SQLiteSpy vs. SQLite.dll speed comparison

Brannon: Thank you for your thoughts. To be clear, the 'optimize for speed' setting in MY release is actually slower than MY debug version - I know nothing about Ralf's settings. That issue is separate from SQLiteSpy - I didn't mean to conflate them. And the issue is not which version of VS I'm