You are analyzing an application.
The application is used to maintain an inventory database and is accessed from several remote Windows client applications.
The application frequently updates multiple rows in a database table by using a DbDataAdapter object. Users report that the application runs slowly during peak business hours. When large number of records are changed by multiple users, you discover the following:
+ The CPU utilization of the client applications is normal
+ The network utilization increases slightly
+ The CPU utilization of the database server remains close to the normal average for a day
You need to resolve the performance issue?
What should you do?
A.
Insert a random time interval between updates.
B.
Move the update method calls to a separate Background Worker thread
C.
Disable batch updates.
Modify the client application to perform a single update
D.
Remove any limit on batch update sizes.
Modify the client application to perform a single update