c# - Can AJAX be used on heavy DB operations -

I have a web application with many drop-downs and grids on it.

At present, when price changes a dropdown, items populate in related drop down (heavy DB operation) and finally the whole page is posted on the server.

Question: Ajax can be recommended in such a situation? I have heard that Ajax is only good for light operations.

You can use Ajax but I would like to provide an alternative solution ...

Use AJAX / Post / whatever you do to start the process, then request feedback on regular intervals using one of these:

• JS voting (Set enterwell)
• Server-Send-Events
• Signal R

  In this way, the user waits for the operation to complete While jar can go away. When the "action has been completed" response is received, you can alert the user with a systematic maintenance alert or email if the more appropriate.