Optimize table updates - any ideas?

[Ben]

I have run into this situation more than once and its time to gather up ideas!

When attempting to transfer large data -set to a table, we are seeing delay times of from 3 to 6 seconds depending on what machine we run our benchmarks.

The data set can be 250K lines and can be as large as 30Meg on disk!

We have issolated the performance issue to ONLY the time required to update the table.

Using the technique to defer FP updates, hide table, update table, show table, undefer updates has improved performance.

So....

I am toying with writing my own Xcontrol but before I do, I'm looking for other ideas and suggestions.

So what do YOU think?

Ben

Cross posted on LAVA.

Message Edited by Ben on 09-07-2007 09:19 AM

[F._Schubert]

One time I was setting a lot of properties on a table (changing bg color for individual cells...) on a slow machine. What I did, was to first update the visible section and setting the other cells later.

Felix