Joost Hopmans e683db244e Merge pull request #639 in KC/kopanocore from ~BSIMONSEN/kopanocore:kc5-sqllimit to master 7 år sedan
..
include 0f1c330ea3 libserver: use initialization and in-class defaults 7 år sedan
ECABObjectTable.cpp 6f49c71215 libserver: gracefully handle allocation failures 7 år sedan
ECABObjectTable.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECAttachmentStorage.cpp 272325e3c4 libserver: add further LIMIT clauses to SELECT statements 7 år sedan
ECAttachmentStorage.h 0f1c330ea3 libserver: use initialization and in-class defaults 7 år sedan
ECCacheManager.cpp 272325e3c4 libserver: add further LIMIT clauses to SELECT statements 7 år sedan
ECCacheManager.h 52d0f950fc libserver: use move semantics for ECsIndexProp 7 år sedan
ECConvenientDepthABObjectTable.cpp 6f49c71215 libserver: gracefully handle allocation failures 7 år sedan
ECConvenientDepthABObjectTable.h 20e9ee58b0 libserver: repair type punning 8 år sedan
ECConvenientDepthObjectTable.cpp 6f49c71215 libserver: gracefully handle allocation failures 7 år sedan
ECConvenientDepthObjectTable.h 20e9ee58b0 libserver: repair type punning 8 år sedan
ECConversion.cpp a55d10f351 provider: consistent use of s_alloc/s_free (3/6) 7 år sedan
ECConversion.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECDBDef.h f5807d31ad libserver: let PRI keys not be NULL 8 år sedan
ECDatabase.h 08d8fc957d libserver: set default class member values 7 år sedan
ECDatabaseFactory.cpp be6f6599ce libserver: replace ECDatabaseMySQL name by ECDatabase 7 år sedan
ECDatabaseFactory.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECDatabaseMySQL.cpp dbda3275c1 Merge pull request #630 in KC/kopanocore from ~BSIMONSEN/kopanocore:use-autocommit-0-where-possible to master 7 år sedan
ECDatabaseUpdate.cpp b1afdf7ee7 libserver: simplify small functions to be even smaller 7 år sedan
ECDatabaseUpdate.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECDatabaseUtils.cpp f160ba86a2 treewide: simplify small functions to be even smaller 7 år sedan
ECDatabaseUtils.h f88f537775 treewide: drop redundant access control specifiers 7 år sedan
ECGenProps.cpp 272325e3c4 libserver: add further LIMIT clauses to SELECT statements 7 år sedan
ECGenProps.h 355bdaf00a libserver: drop useless access specifier in class ECGenProps 7 år sedan
ECGenericObjectTable.cpp 4f6090e0b6 Merge branch 'release' 7 år sedan
ECGenericObjectTable.h f88f537775 treewide: drop redundant access control specifiers 7 år sedan
ECICS.cpp 272325e3c4 libserver: add further LIMIT clauses to SELECT statements 7 år sedan
ECICS.h 6e15c6f498 libserver: remove unused function CleanupChangesTable 8 år sedan
ECICSHelpers.cpp 6f49c71215 libserver: gracefully handle allocation failures 7 år sedan
ECICSHelpers.h f88f537775 treewide: drop redundant access control specifiers 7 år sedan
ECIndexer.cpp d4e9ba8d0f provider: consistent use of s_alloc/s_free (4/6) 7 år sedan
ECIndexer.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECKrbAuth.cpp 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECKrbAuth.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECLockManager.cpp 85f8454abc libserver: use shared_mutex class in ECLockManager 7 år sedan
ECLockManager.h 85f8454abc libserver: use shared_mutex class in ECLockManager 7 år sedan
ECMAPI.h 2a5437fbcc Initial commit 8 år sedan
ECMailBoxTable.cpp 6f49c71215 libserver: gracefully handle allocation failures 7 år sedan
ECMailBoxTable.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECMultiStoreTable.cpp 6f49c71215 libserver: gracefully handle allocation failures 7 år sedan
ECMultiStoreTable.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECNotification.cpp 2f624c0389 provider: consistent use of s_alloc/s_free (5/6) 7 år sedan
ECNotification.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECNotificationManager.cpp f160ba86a2 treewide: simplify small functions to be even smaller 7 år sedan
ECNotificationManager.h 0f1c330ea3 libserver: use initialization and in-class defaults 7 år sedan
ECPamAuth.cpp 3166997125 treewide: replace type repetitions by "auto" in casting statements 7 år sedan
ECPamAuth.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECPluginFactory.cpp 0f1c330ea3 libserver: use initialization and in-class defaults 7 år sedan
ECPluginFactory.h 0f1c330ea3 libserver: use initialization and in-class defaults 7 år sedan
ECPluginSharedData.cpp 0f1c330ea3 libserver: use initialization and in-class defaults 7 år sedan
ECS3Attachment.cpp 64c316f15e treewide: promote some reinterpret_cast to static_cast 7 år sedan
ECS3Attachment.h 0f1c330ea3 libserver: use initialization and in-class defaults 7 år sedan
ECSearchFolders.cpp 272325e3c4 libserver: add further LIMIT clauses to SELECT statements 7 år sedan
ECSearchFolders.h 0f1c330ea3 libserver: use initialization and in-class defaults 7 år sedan
ECSearchObjectTable.cpp 6f49c71215 libserver: gracefully handle allocation failures 7 år sedan
ECSearchObjectTable.h 20e9ee58b0 libserver: repair type punning 8 år sedan
ECSecurity.cpp f160ba86a2 treewide: simplify small functions to be even smaller 7 år sedan
ECSecurity.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECServerEntrypoint.cpp 056ecbba15 provider: stash SOAPINFO casting into separate function 7 år sedan
ECServerEntrypoint.h 056ecbba15 provider: stash SOAPINFO casting into separate function 7 år sedan
ECSession.cpp f62d03393f libserver: replace "select" by "poll" 7 år sedan
ECSession.h 0f1c330ea3 libserver: use initialization and in-class defaults 7 år sedan
ECSessionGroup.cpp 91e75f76e3 provider: consistent use of s_alloc/s_free (6/6) 7 år sedan
ECSessionGroup.h b22f293ecd build: resolve some clang warnings 7 år sedan
ECSessionManager.cpp 3166997125 treewide: replace type repetitions by "auto" in casting statements 7 år sedan
ECSessionManager.h 427df3e8f7 libserver: use shared_mutex class in ECSessionManager 7 år sedan
ECStatsCollector.cpp 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECStatsCollector.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECStatsTables.cpp 6f49c71215 libserver: gracefully handle allocation failures 7 år sedan
ECStatsTables.h 20e9ee58b0 libserver: repair type punning 8 år sedan
ECStoreObjectTable.cpp b50bc6f8f5 libserver: reduce nesting level in source 7 år sedan
ECStoreObjectTable.h 0f1c330ea3 libserver: use initialization and in-class defaults 7 år sedan
ECStringCompat.cpp e13c166ef4 treewide: deindent case label statements (6/7) 8 år sedan
ECStringCompat.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECSubRestriction.cpp 1308066560 libserver: release SQL result from ~DB_RESULT 7 år sedan
ECSubRestriction.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECTPropsPurge.cpp f160ba86a2 treewide: simplify small functions to be even smaller 7 år sedan
ECTPropsPurge.h 0f1c330ea3 libserver: use initialization and in-class defaults 7 år sedan
ECTableManager.cpp 6f49c71215 libserver: gracefully handle allocation failures 7 år sedan
ECTableManager.h 0f1c330ea3 libserver: use initialization and in-class defaults 7 år sedan
ECTestProtocol.cpp 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECTestProtocol.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
ECUserManagement.cpp b50bc6f8f5 libserver: reduce nesting level in source 7 år sedan
ECUserManagement.h 1b08d97d15 build: work around gcc 4.7 dtor behavior 7 år sedan
ECUserStoreTable.cpp 6f49c71215 libserver: gracefully handle allocation failures 7 år sedan
ECUserStoreTable.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
README.md 0d3875268e doc: update code structure documentation 8 år sedan
StorageUtil.cpp 272325e3c4 libserver: add further LIMIT clauses to SELECT statements 7 år sedan
StorageUtil.h 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
StreamUtil.cpp e9b4fdd12e Merge KC-PR-631 7 år sedan
StreamUtil.h a50ba602ac misc: add static/const qualifiers for functions and data 7 år sedan
cmd.cpp 272325e3c4 libserver: add further LIMIT clauses to SELECT statements 7 år sedan
cmd.hpp 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan
cmdutil.cpp 272325e3c4 libserver: add further LIMIT clauses to SELECT statements 7 år sedan
cmdutil.hpp 26dffb479b build: ensure exception includes are present 7 år sedan
logontime.cpp 272325e3c4 libserver: add further LIMIT clauses to SELECT statements 7 år sedan
logontime.hpp 2d60ab3890 treewide: place all symbols into a namespace 8 år sedan

README.md

Libserver

ECCacheManager

The ECCacheManager caches some specific MySQL table items in a hash map. For example for the hierarchtable it is stored as . When the cache limit is hit, we randomly remove 5% of the items.

The sort() operation on unordered hashmaps is very expensive so you might notice cache spikes everytime the cache is cleaned. A possible solution is randomly removing the cache entries.

         +-------------------------------------------------------------+
         |                                                             |
         |                                                             |
cache --+|                  xxxxxxxx xxxxxxxx xxxxxxxxxx xxxxxxxxxxxxxx|
limit    |               xxx       x x      x x        x x             |
         |            xxxx          x        x          x              |
         |         xxxx                                                |
         |        xx                                                   |
         |     xxx                                                     |
         |  xxxx                                                       |
         |xxx                                                          |
         xx------------------------------------------------------------+