¡@

Home 

python Programming Glossary: fk_msms_precursor_spectrum_spectrum_id_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

rows ' 0 2 0 u'SEARCH TABLE MSMS_precursor USING INDEX fk_MSMS_precursor_spectrum_spectrum_id_1 spectrum_spectrum_id ~5 rows ' query took 0.0754859447479 seconds.. rows ' 0 2 0 u'SEARCH TABLE MSMS_precursor USING INDEX fk_MSMS_precursor_spectrum_spectrum_id_1 spectrum_spectrum_id ~5 rows ' query took 0.579694032669 seconds.. rows ' 0 2 0 u'SEARCH TABLE MSMS_precursor USING INDEX fk_MSMS_precursor_spectrum_spectrum_id_1 spectrum_spectrum_id ~5 rows ' query took 1.01185703278 seconds..