| Anonymous | Login | Signup for a new account | 03-12-25 22:37 CET |  |
| Main | My View | View Issues | Change Log | Roadmap |
| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |
| 0001642 | SphereServer | executable - generic | public | 14-08-09 19:03 | 30-08-09 05:18 | |
| Reporter | Valarin | |||||
| Assigned To | MrSugarCube | |||||
| Priority | normal | Severity | major | Reproducibility | always | |
| Status | resolved | Resolution | fixed | |||
| Platform | OS | OS Version | ||||
| Product Version | ||||||
| Target Version | Fixed in Version | 20-09-2009, 0.56b Prerelease | ||||
| Summary | 0001642: Asynchronous queries low performance | |||||
| Description | Sphere 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. | |||||
| Additional Information | See http://www.sphereserver.net/index.php?showtopic=46971 [^] | |||||
| Tags | No tags attached. | |||||
| Nightly Version | 09-09-2008 | |||||
| Experimental Flags | UseNetworkMulti | |||||
| Option Flags | None | |||||
| Internal Build Number | ||||||
| Attached Files | ||||||
 Relationships |
|
 Relationships |
|
Notes |
|
|
(0000266) MrSugarCube (administrator) 30-08-09 05:18 edited on: 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. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 14-08-09 19:03 | Valarin | New Issue | |
| 14-08-09 19:03 | Valarin | Nightly Version | => 09-09-2008 |
| 14-08-09 19:03 | Valarin | Experimental Flags | => UseNetworkMulti |
| 14-08-09 19:03 | Valarin | Option Flags | => None |
| 30-08-09 05:18 | MrSugarCube | Status | new => resolved |
| 30-08-09 05:18 | MrSugarCube | Fixed in Version | => 0.56c Nightly |
| 30-08-09 05:18 | MrSugarCube | Resolution | open => fixed |
| 30-08-09 05:18 | MrSugarCube | Assigned To | => MrSugarCube |
| 30-08-09 05:18 | MrSugarCube | Note Added: 0000266 | |
| 30-08-09 05:18 | MrSugarCube | Note Edited: 0000266 | |
|
Issue History |
| Copyright © 2000 - 2010 MantisBT Group |
 |