SphereServer BugTracker - SphereServer
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0001642SphereServerexecutable - genericpublic14-08-09 19:0330-08-09 05:18
ReporterValarin 
Assigned ToMrSugarCube 
PrioritynormalSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version20-09-2009, 0.56b Prerelease 
Nightly Version09-09-2008
Experimental FlagsUseNetworkMulti
Option FlagsNone
Internal Build Number
Summary0001642: Asynchronous queries low performance
DescriptionSphere can't handle heavy usage of asynchronous queries. The rate of performing queries is about one query per two seconds - to be more precise, callbacks functions are called at this rate and if asynchronous queries used in faster rate, the queue is eventually overfilled and sphere database connection crashes and needs restarting to connect to DB server again.
Steps To Reproduce
Additional InformationSee http://www.sphereserver.net/index.php?showtopic=46971 [^]
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
14-08-09 19:03ValarinNew Issue
14-08-09 19:03ValarinNightly Version => 09-09-2008
14-08-09 19:03ValarinExperimental Flags => UseNetworkMulti
14-08-09 19:03ValarinOption Flags => None
30-08-09 05:18MrSugarCubeStatusnew => resolved
30-08-09 05:18MrSugarCubeFixed in Version => 0.56c Nightly
30-08-09 05:18MrSugarCubeResolutionopen => fixed
30-08-09 05:18MrSugarCubeAssigned To => MrSugarCube
30-08-09 05:18MrSugarCubeNote Added: 0000266
30-08-09 05:18MrSugarCubeNote Edited: 0000266

Notes
(0000266)
MrSugarCube   
30-08-09 05:18   
I found a 1 second delay between callbacks and have reduced this (1000 queries here now takes 3 minutes (+2 seconds) for all callbacks to complete), although I'm not sure how useful this will be if you're really running thousands of queries per minute since there'll always be a significant delay if you need to wait for all the callbacks to complete.