top button
Flag Notify
Site Registration

RDBMS: What is Multi Threaded Server (MTA)?

0 votes
322 views
RDBMS: What is Multi Threaded Server (MTA)?
posted Jan 6, 2015 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

In a Single Threaded Architecture (or a dedicated server configuration) the database manager creates a separate process for each database user. But in MTA the database manager can assign multiple users (multiple user processes) to a single dispatcher (server process), a controlling process that queues request for work thus reducing the databases memory requirement and resources.

answer Jan 7, 2015 by Arun Gowda
...