Improving table checkpoint performance
Hello all, Does anyone have any tips on improving table checkpoint performance? I have many (200+) table checkpoints for the DevEx grids in our Delphi based desktop application. It's common for...
Forum Discussion
Hi Robert,
Thanks for the tips. I already have the full object path mapped and aliased, so I don't see any room for improvement there.
Just to be sure, I specifically added mapping and alias for the object I'm testing at the moment, which is about 18 objects deep in the tree, but didn't see any performance improvement.
I do have some procedures already coded to validate individual grid cells and rows, I'll play around with those and see what the performance difference is.
Allen
And the results are:
Validating an individual cell by getting [Grid].wValue takes half a second (0.468).
Attempting to loop through the grid by rows or columns appears to scale linearly:
Looping through 38 columns on a specified row searching for two specified column+value pairs takes 19 seconds.
Looping through rows on a specified column to find a specific row by value takes 2.2 seconds to find the match on row 5.
And as I said before, a Table check against the entire grid takes around 21 seconds.
I had hoped there would be some optimized way to grab and compare an entire specified row, but it looks like there's no such thing as a free lunch. If I want performance, I have to check against a small set of known column+row values.
Thanks.
Allen