[Solved] How to disable screen refresh - redrawing

[ptsenter]

Hi,
I have to insert 4+ million numbers into a spreadsheet. Right now I use setValue. It works, but takes hours (actually, 20+). My guess is the main reason calc redraws screen after each insert. Is it possible to disable redrawing and make refresh by request only, e.g., redraw after 1000 numbers only. It seems I saw similar question already, but cannot find it any more.
Thank you.

[Villeroy]

Every API-call costs a lot of time. Use range.setDataArray(aRows(aColumns()))

[ptsenter]

Thank you for your suggestion - it definitely works: even on a small matrix 20x120 copying one row as a single range gives me 6 - 10 times improvement.
But it turned out we have a much bigger problem: calc cannot handle spreadsheet that huge properly - it becomes slow or completely unresponsive. We have to do some preprocessing before moving data to spreadsheet and losing some flexibility. Oh, well.

[Villeroy]

Without knowing anything about your concrete problem. Could it be that you are implementing a database in a spreadsheet? Do you have many thousands of lookups?

[ptsenter]

There is no database and no executable code yet, just holding numbers (double) - at the moment 3 million, in production it might go up to 15 mil.

[ms777]

My recommendation: do not even try to use caalc for 15 mio numbers. Use base.

[probe1]

ms777,
have you tried Base with millions of records?

I have done so with some thousands
I would use a real DBMS.

[Villeroy]

ms777,
have you tried Base with millions of records?

I have done so with some thousands
I would use a real DBMS.

Thank you, you saved me some time and a "killall soffice.bin"