biglad
06-28-2009, 12:53 PM
Implemented separate connection for SqlDelayThread This should result in less locking when accessing database, and improved performance. * Changed SqlDelay queue type to monitored queue, and removed 10ms check period. thanks to Derex, mknjc, Jeniczek and Christyan for ideas and tests.
src/shared/Database/SqlDelayThread.h (http://bitbucket.org/biglad/mga/src/dd9df6856ebd/src/shared/Database/SqlDelayThread.h) (5 lines added, 3 lines removed)
src/shared/Database/SqlDelayThread.cpp (http://bitbucket.org/biglad/mga/src/dd9df6856ebd/src/shared/Database/SqlDelayThread.cpp) (17 lines added, 10 lines removed)
src/shared/Database/MySQLDelayThread.h (http://bitbucket.org/biglad/mga/src/dd9df6856ebd/src/shared/Database/MySQLDelayThread.h) (1 lines added, 1 lines removed)
src/shared/Database/Database.h (http://bitbucket.org/biglad/mga/src/dd9df6856ebd/src/shared/Database/Database.h) (1 lines added, 1 lines removed)
src/shared/Database/DatabaseMysql.h (http://bitbucket.org/biglad/mga/src/dd9df6856ebd/src/shared/Database/DatabaseMysql.h) (2 lines added, 2 lines removed)
src/shared/Database/DatabaseMysql.cpp (http://bitbucket.org/biglad/mga/src/dd9df6856ebd/src/shared/Database/DatabaseMysql.cpp) (5 lines added, 5 lines removed)
More... (http://bitbucket.org/biglad/mga/changeset/dd9df6856ebd/)
src/shared/Database/SqlDelayThread.h (http://bitbucket.org/biglad/mga/src/dd9df6856ebd/src/shared/Database/SqlDelayThread.h) (5 lines added, 3 lines removed)
src/shared/Database/SqlDelayThread.cpp (http://bitbucket.org/biglad/mga/src/dd9df6856ebd/src/shared/Database/SqlDelayThread.cpp) (17 lines added, 10 lines removed)
src/shared/Database/MySQLDelayThread.h (http://bitbucket.org/biglad/mga/src/dd9df6856ebd/src/shared/Database/MySQLDelayThread.h) (1 lines added, 1 lines removed)
src/shared/Database/Database.h (http://bitbucket.org/biglad/mga/src/dd9df6856ebd/src/shared/Database/Database.h) (1 lines added, 1 lines removed)
src/shared/Database/DatabaseMysql.h (http://bitbucket.org/biglad/mga/src/dd9df6856ebd/src/shared/Database/DatabaseMysql.h) (2 lines added, 2 lines removed)
src/shared/Database/DatabaseMysql.cpp (http://bitbucket.org/biglad/mga/src/dd9df6856ebd/src/shared/Database/DatabaseMysql.cpp) (5 lines added, 5 lines removed)
More... (http://bitbucket.org/biglad/mga/changeset/dd9df6856ebd/)