Created
August 14, 2016 13:18
-
-
Save lfdversluis/5c49ec6dcc73cc20f1b690c9d174229c to your computer and use it in GitHub Desktop.
2016-08-14 tribler sync db stuff
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ------- 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 | |
| ----------------- |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment