Inlineedit GridRow - Save Takes very long to update Row

Title:

BI{code} ?

I have a Grid with 40.000 items. When i push the Save Button It takes very long to Update the Row. The Value is updated instantly in Database. But the Row needs 5-6 seconds to update. Do i have to initialise the grid diffrent for that much items?

Save Changes Cancel

c4

asked at 29 Mar 2019

Answers

• BI{code} ?

  using our grid inline edit demo as reference, when you click save first the `Post` `Edit` action will execute and after that `GridGetItems` action with `g.Key` property set so `GetItem = () => Db.Get<Dinner>(Convert.ToInt32(g.Key))` will execute, check this line in your code and make sure it doesn't pull the whole table from the `Db` for sql server I can recommend using `ExpressProfiler` to check what sql was generated on each request

  Save Changes Cancel

  

  Omu

  answered at 29 Mar 2019

  • mmmhhh allright Sir, ill check that.
    at 29 Mar 2019 c4

please Sign In to leave an answer