[sqlite] select speed is too slow

Hello All, I found it is too slow when i do a query first time after i restart my pc, can anyone give some advice for this problem? For eg, the query like this: "select count(id) from tab1" ,and the record number is above 100,000. If i can't restart my pc, the speed is quicker when i do the

Re: [sqlite] sqlite3_open_v2 performance degrades as number of opens increase

I'll explain our needs a little more and then perhaps you can tell me if the current approach is the optimal one or not. In our application, if we were to have a single file, due to the billions of records we need to store, the file would easily exceed the 14TB maximum limit of a database file.

Re: [sqlite] Unicode Confusion and Database Size

Hi Simon, On 4/9/2011 12:01 AM, Simon Slavin wrote: Have you tried speed tests on your platform ? It's hard to tell which will be faster because it depends on what language and OS you're using that interacts with SQLite. So if you have your schema designed and any part of your application

Re: [sqlite] how to return these data from the DB

LiranR wrote: > For > example: > Time |data > --- > 5 |x > 7 |y > 9 |z > 11 | i > 13 | j > 15 | k > > Now, when i want from time 8 (8 is not in the table) to time 13 i will get : > > 9 z > 11 i > 13

[sqlite] how to return these data from the DB

Hi all! I have a table which has an index column ( its name is 'Time' ). I want to be able to return number of rows - the rows are from a given time to a second given time. The thing is that the given time could also not be in the table. For example: Time |data --- 5 |

Re: [sqlite] Speeding up index creation

Updated results against current trunk: CPU Time: user 82.009726 sys 129.636831 I rerun the profiler and looked at the results. Most of them looked sensible, but one thing still struck me. Once the new index is created in the VDBE Sorter it gets copied back into the new Btree using a loop with