Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 4 of 4 total |
Hundreds of SQL to Server |
Wed, Apr 5 2006 1:18 PM | Permanent Link |
Bruce | Hi,
I am running a process that is sending hundreds of SQL insert, update, and select statements to the server very quickly. Several minutes into the process, the server crashes. Using 4.31b2, I was getting out of memory errors. Using 4.32b2, I am getting 'access denied' or other undefined exceptions at the server. My whole system then becomes extremely sluggish until I kill off the server in task manager. FWIW, I am using the ADO.NET provider from ContextSoft, but I haven't seen this issue after months of using this product. Are there any known issues or problems with what I am trying to do? --Bruce |
Wed, Apr 5 2006 2:10 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bruce,
<< I am running a process that is sending hundreds of SQL insert, update, and select statements to the server very quickly. Several minutes into the process, the server crashes. Using 4.31b2, I was getting out of memory errors. Using 4.32b2, I am getting 'access denied' or other undefined exceptions at the server. My whole system then becomes extremely sluggish until I kill off the server in task manager. >> The version numbers that you're using are off a bit - are you talking about versions 4.22 and 4.23 ? << FWIW, I am using the ADO.NET provider from ContextSoft, but I haven't seen this issue after months of using this product. >> They use their own client layer to our database server, so I can't say one way or the other if this their issue or not since I don't know. << Are there any known issues or problems with what I am trying to do? >> Not that I'm aware of. It shouldn't matter how fast you send the SQL statements to the database server, it will simply execute them in a serialized fashion using the same session, with one waiting until the other is done. Did you try the same process with a TDBISAMQuery ? That should at least tell us if the problem exists with the native DBISAM client layer. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Apr 5 2006 5:49 PM | Permanent Link |
"Donat Hebert \(WSI\)" | <<I am getting 'access denied' or other undefined exceptions at the server.
My whole system then becomes extremely sluggish until I kill off the server in task manager.>> Bruce, I don't know if this applies to your system however we were getting these types of errors where we were pushing the server extremely hard and the server was trying to create another session for another user process. Errors like: Access denied or file not found or violation errors ... I turned up our default DatabaseSessions (We're using Asta server - StartThreading implementation) and the problems all went away. Its not clear if the hundreds of SQL are all in the same session or not. We also checked for timers firing which created an extra burden during heavy processing. We disabled the client timer so it wouldn't fire until the the main job was done. This further reduced the need for so many open sessions. In case this helps .. Donat. |
Thu, Apr 6 2006 4:16 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Donat,
<< Bruce, I don't know if this applies to your system however we were getting these types of errors where we were pushing the server extremely hard and the server was trying to create another session for another user process. Errors like: Access denied or file not found or violation errors .... I turned up our default DatabaseSessions (We're using Asta server - StartThreading implementation) and the problems all went away. Its not clear if the hundreds of SQL are all in the same session or not. We also checked for timers firing which created an extra burden during heavy processing. We disabled the client timer so it wouldn't fire until the the main job was done. This further reduced the need for so many open sessions. In case this helps .. Donat. >> This is probably a different issue altogether. DBISAM's database server executes all requests/responses in a given remote session serially, meaning that it is impossible to "overload" the server with one session in terms of sending many, many SQL requests. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |