Hi, I've a program made using gcc/C++ compiler (with Win32/dev-cpp) and an ready-made sqlite3 lib using v3.5.6. I try to optimize my code, and the gprof tool give me :
Each sample counts as 0.01 seconds. % cumulative self self total time seconds seconds calls ms/call ms/call name 25.19 224.40 224.40 sqlite3_enable_shared_cache 10.55 318.40 94.00 sqlite3_sql 9.46 402.70 84.30 winCurrentTime 5.50 451.70 49.00 sqlite3_blob_open 3.13 479.62 27.92 BZ2_decompress ... index % time self children called name <spontaneous> [1] 25.2 224.40 0.00 sqlite3_enable_shared_cache [1] ----------------------------------------------- <spontaneous> [2] 10.6 94.00 0.00 sqlite3_sql [2] ----------------------------------------------- <spontaneous> [3] 9.5 84.30 0.00 winCurrentTime [3] ----------------------------------------------- <spontaneous> [4] 5.5 49.00 0.00 sqlite3_blob_open [4] ----------------------------------------------- <spontaneous> [5] 3.9 4.10 30.40 doContent [5] 5.71 10.14 17425337/17425337 ParserOsm::startElementHandler(void*, char const*, char const**) [12] 1.35 13.19 17425337/17425337 ParserOsm::endElementHandler(void*, char const*) [14] ----------------------------------------------- <spontaneous> [6] 3.1 27.92 0.00 BZ2_decompress [6] ----------------------------------------------- ... Of course I never called sqlite3_enable_shared_cache() in my source code :-) . Any idea how to reduce this function call and the time spended in it. Regards, -- Marc _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users