[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    [sqlite] Why so much sqlite3_enable_shared_cache()
From:       Marc SIBERT <marc () sibert ! fr>
Date:       2009-02-28 15:19:05
Message-ID: 49A955E9.6040408 () sibert ! fr
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]