EditTable slow (OpenInsight 32-bit)
At 04 SEP 2020 04:26:47AM cmeyer wrote:
Client complaining about slow large edit table.
I have a data bound edit table with 15 columns and up to 250 rows where the first 2 columns are imported from an email. The user then has to step through each row to populate the remaining data via a dialog box. With such a large row count the data entry becomes very slow.
Is there any way to turn off the calculate function to see if that helps. I have tried turning off the redraw without success.
Is there any way of speeding up an edit table.
Any advice would be grateful.
Chris
At 04 SEP 2020 04:55AM Carl Pates wrote:
Chris,
You really need to determine where the slowdown actually is - maybe using an OEPROFILE.LOG might help? .
If it's the CALCULATE event as you suspect, then you can turn this off via one of three ways:
1) Have an event script in the CALCULATE event that knows when it should execute (user is not done editing etc ) and only let it run the system CALCULATE processing when you need it.
2) Use the system BLOCK_EVENTS property (sledgehammer-approach)
3) Use the QUALIFY_EVENT message to turn off the CALCULATE event until you want to run it again.