¡@

Home 

python Programming Glossary: fk_spectrum_scahn_start_time_1

Why is the same SQLite query being 30 times slower when fetching only twice as many results?

http://stackoverflow.com/questions/10531898/why-is-the-same-sqlite-query-being-30-times-slower-when-fetching-only-twice-as-m

~100000 rows ' 0 1 1 u'SEARCH TABLE spectrum USING INDEX fk_spectrum_scahn_start_time_1 scan_start_time AND scan_start_time ~3125 rows ' 0 2 0 u'SEARCH.. ~100000 rows ' 0 1 1 u'SEARCH TABLE spectrum USING INDEX fk_spectrum_scahn_start_time_1 scan_start_time AND scan_start_time ~3125 rows ' 0 2 0 u'SEARCH.. ~100000 rows ' 0 1 1 u'SEARCH TABLE spectrum USING INDEX fk_spectrum_scahn_start_time_1 scan_start_time AND scan_start_time ~3125 rows ' 0 2 0 u'SEARCH..