Midas application server block client access

The app server remote datamodule threading model is MultiInstance / Apartment,
and I connect to SQL server using ADO.

When a client connect to the app server and call a time consuming database query interface, then other clients all blocked until the query finished.

I have tried to connect using DCOM connection and Socket connection, same thing happens.

It seems that all job are queued by midas app server, and the server services client access one by one.

Why this happens? How to solve?
qdyoungAsked:
Who is Participating?
 
swift99Connect With a Mentor Commented:
Your server is running a single thread.  To gain parallelism, you need to split the communications thread from the database connectivity thread, and actually run several concurrent database connection threads.  For an enterprise scale service with a robust back end, 100 to 200 connections might be a good range to support.  For a WIntel based DBMS back end (MS SQL, Interbase, etc) I generally suggest one or two database threads per CPU.

For something a bit more robust for the communications piece, check out Midware from overbyte.delphicenter.com.  Midware allows you to separate the command logic from the database logic so that you can serve long requests in a separate thread.  The TWSocket communication component itself is non-blocking, so you can serve several thousand users concurrently from one communications thread.
0
 
swift99Commented:
Allow one connection for every 50 users
0
 
swift99Commented:
What is your back end DBMS - does it multithread?  if not, then you're in trouble.
0
 
qdyoungAuthor Commented:
My backend DBMS is Microsoft SQL Server 2000.

Any real parallelism solution for Delphi MIDAS?
0
 
swift99Commented:
I use the MIDAS piece in briefcase model, and use direct API calls to the DB2 system here.  The MIDAS provider interface was not scalable enough for my purposes.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.