Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Hundreds of SQL to Server
Wed, Apr 5 2006 1:18 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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

Image