>Have you tried compiling with the profiler and seeing where the time is being spent?
I compiled with the profiler and used prof to analyze the mon.out file. The program took 47 seconds to run, but the results only account for .39 seconds I do compile sqlite3.c into sqlite3.o then link it into my project, but I compiled that with profiling too. I'm not sure if that will make a difference. Does this give anybody ideas, or is there something else I should try? %Time Seconds Cumsecs #Calls msec/call Name 1.1 0.08 0.08 sqlite3_result_int 0.9 0.07 0.15 1075436 0.00 _Z19ReadSQLiteComponentiiP12sqlite3_stmt 0.9 0.07 0.22 sqlite3_value_text 0.5 0.04 0.26 1 40.00 main 0.5 0.04 0.30 sqlite3_context_db_handle 0.3 0.02 0.32 sqlite3_column_text 0.3 0.02 0.34 sqlite3_free 0.1 0.01 0.35 101001 0.00 _ZNSi4readEPclii 0.1 0.01 0.36 1001 0.01 _Z8ReadLineRSt14basic_ifstreamIcSt11char_traitsIcEE 0.1 0.01 0.37 sqlite3_bind_text 0.1 0.01 0.38 sqlite3_column_int 0.1 0.01 0.39 sqlite3_step 0.0 0.00 0.39 269863 0.00 _ZNSi13_C_unsafe_getEPlii 0.0 0.00 0.39 101001 0.00 _ZNSi7_C_ipfxEi 0.0 0.00 0.39 532 0.00 _ZN8GDRecord8addFieldEPK7GDField 0.0 0.00 0.39 532 0.00 _ZNKSt7codecvtIcc9mbstate_tE16do_always_noconvEv 0.0 0.00 0.39 532 0.00 _ZNSt13basic_filebufIcSt11char_traitsIcEE9underflowEv 0.0 0.00 0.39 8 0.00 _ZNSt13basic_filebufIcSt11char_traitsIcEE4syncEv 0.0 0.00 0.39 4 0.00 _ZNKSt5ctypeIwE8do_widenEc 0.0 0.00 0.39 4 0.00 _ZNSt13basic_filebufIcSt11char_traitsIcEE6setbufEPcl 0.0 0.00 0.39 2 0.00 _ZN4__rw15__rw_facet_base12_C_initfacetERKSt6locale 0.0 0.00 0.39 1 0.00 _ZN4__rw11__rw_file_t15_C_get_mode_argEi 0.0 0.00 0.39 1 0.00 _ZN4__rw15__rw_mutex_baseD2Ev 0.0 0.00 0.39 1 0.00 _ZN4__rw16__rw_facet_makerISt5ctypeIcEE13_C_maker_funcEiPKcm 0.0 0.00 0.39 1 0.00 _ZN4__rw16__rw_facet_makerISt7codecvtIcc9mbstate_tEE13_C_maker_funcEiPKc m 0.0 0.00 0.39 1 0.00 _ZNSiD2Ev 0.0 0.00 0.39 1 0.00 _ZNSt13basic_filebufIcSt11char_traitsIcEE4openEPKcil 0.0 0.00 0.39 1 0.00 _ZNSt13basic_filebufIcSt11char_traitsIcEE5closeEv 0.0 0.00 0.39 1 0.00 _ZNSt13basic_filebufIcSt11char_traitsIcEEC1Ev 0.0 0.00 0.39 1 0.00 _ZNSt9basic_iosIcSt11char_traitsIcEED2Ev _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
