It is necessary to improve the code to avoid constant refreshments and speed up. I modified your example to get the maximum speed.
Obviously, if there are many lines, it takes time
Some suggestions:
- If there are many lines it is better not to activate the refresh in the Add command. But rather use invalidate when the entire table has been populated.
- If you have a recursive sub do not use invalidate inside it otherwise it will be called many times and it will slow down everything