On 19 Dec 2009, at 9:10pm, Robert Citek wrote: > However, times take noticeably longer when the dataset size is doubled > to 2 MM records. Querying+index (~160=136+20) took 4x longer than > with the 1 MM dataset,
This is not surprising. Twice as much data leading to 4x access time. > although it was still 4x faster than querying > without an index (~610s). Okay, that's reasonable too. But your basic timing is unexpectedly high, as you posted initially. > Piping to the sort command was still the > fastest at 12s, more than 13x faster than querying with an index This seems to be significant but I don't know what it means. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
