ApplyUpdates hangs

Data Abstract
1

D2010 with all the updates, RODA 6.0.53.935, MS SQL 2000 database.

For some reason, when i call ApplyUpdates on TDAMemDataTable, application hangs and
application server CPU usage goes to 20%.

Application Server uses TDAHetConnection component, if it helps…I understand its hard to make
suggestions based on the above. Maybe there is some known issue or something like that…

Thanks.

2

Also, if i terminate client app from Task Manager, CPU usage on app server goes back to normal.

3

Hello,
Please, describe your project more detail:
What DA driver do you use?
How many records do you update?
What extra parameters do you use?
Do you use SQL server on the same computer?
Can you test your project with the latest winter trial version?
Can you send us a small testcase which reproduces it?

4

I’ve managed to solve it. The problem was with ApplyUpdates call being placed in OnAfterPost event handler. It seems DA doesnt like it.

I’ve put a timer there and do ApplyUpdates in timer event.

5

you can use RemoteUpdatesOptions property of TDAMemDataTable:
from http://wiki.remobjects.com/wiki/TDADataTable_Class:

RemoteUpdatesOptions

Provides options for applying updates to the server. Available options include:
Changes to records will automatically be applied to the server as they are posted. Enable this option to achieve behavior similar to single- or two-tier database applications, where posting a record in the user interface will directly apply the change to the back-end database. This basically triggers an automatic call to ApplyUpdates for each record change.