2016-08-14 tribler sync db stuff

gistfile1.txt

------- fetchall --------
Times called: 91661 
total time: 278.319 seconds
avg: 0.00304
min: 0.00000
max: 0.23420
Total amount of functions calling this db function: 20
Top 5 callers issuing the heaviest query:
 (234 ms) Function getRecentAndRandomTorrents at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 1846
 (208 ms) Function getPeerIDS at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 101
 (205 ms) Function getPeerIDS at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 101
 (195 ms) Function getPeerIDS at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 101
 (183 ms) Function getPeerIDS at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 101
-----------------

------- execute --------
Times called: 218818 
total time: 16.142 seconds
avg: 0.00007
min: 0.00000
max: 0.21455
Total amount of functions calling this db function: 13
Top 5 callers issuing the heaviest query:
 (214 ms) Function commit_now at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/sqlitecachedb.py line 228
 (198 ms) Function commit_now at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/sqlitecachedb.py line 228
 (193 ms) Function commit_now at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/sqlitecachedb.py line 228
 (182 ms) Function commit_now at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/sqlitecachedb.py line 228
 (165 ms) Function commit_now at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/sqlitecachedb.py line 228
-----------------

------- executemany --------
Times called: 22558 
total time: 10.414 seconds
avg: 0.00046
min: 0.00000
max: 0.06059
Total amount of functions calling this db function: 16
Top 5 callers issuing the heaviest query:
 (60 ms) Function on_remove_votes_from_dispersy at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 1188
 (55 ms) Function on_remove_votes_from_dispersy at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 1188
 (52 ms) Function on_remove_votes_from_dispersy at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 1188
 (50 ms) Function on_remove_votes_from_dispersy at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 1188
 (49 ms) Function on_remove_votes_from_dispersy at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 1188
-----------------

------- update --------
Times called: 6647 
total time: 22.542 seconds
avg: 0.00339
min: 0.00227
max: 0.22119
Total amount of functions calling this db function: 6
Top 5 callers issuing the heaviest query:
 (221 ms) Function addExternalTorrentNoDef at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 338
 (23 ms) Function addExternalTorrentNoDef at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 338
 (22 ms) Function addExternalTorrentNoDef at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 338
 (21 ms) Function addExternalTorrentNoDef at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 338
 (21 ms) Function addExternalTorrentNoDef at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 338
-----------------

------- insert_or_ignore --------
Times called: 18511 
total time: 50.580 seconds
avg: 0.00273
min: 0.00000
max: 0.16437
Total amount of functions calling this db function: 6
Top 5 callers issuing the heaviest query:
 (164 ms) Function addOrGetPeerID at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 116
 (19 ms) Function addOrGetPeerID at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 116
 (18 ms) Function addOrGetPeerID at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 116
 (18 ms) Function addOrGetPeerID at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 116
 (17 ms) Function addOrGetPeerID at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 116
-----------------

------- fetchone --------
Times called: 87904 
total time: 273.999 seconds
avg: 0.00312
min: 0.00196
max: 0.21972
Total amount of functions calling this db function: 16
Top 5 callers issuing the heaviest query:
 (219 ms) Function getChannelIdFromDispersyCID at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 1367
 (172 ms) Function getOne at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/sqlitecachedb.py line 490
 (157 ms) Function getOne at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/sqlitecachedb.py line 490
 (141 ms) Function getChannelIdFromDispersyCID at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 1367
 (123 ms) Function getChannelIdFromDispersyCID at /home/tribler/Documents/tribler/Tribler/Core/CacheDB/SqliteCacheDBHandler.py line 1367
-----------------