When I make a lookupv to 500,000 records, it takes long time and never finished.
as above when I delete a column or add one in this file with 500,000 records takes about 20 min and does it
And Linux takes a longer time than Windows but in Windows cannot save it just close up the aplication and when i reopen the file it displays the recovery file window.
Hi nain, thanks for reporting.
Please can you attach a sample file.
Hi Nain, looking at your sample file in my opinion maybe calc is not the proper tool to work with a so large number of records and specially with such quantity of formulas like VLOOKUP().
I think is a job for a database, in the documentation you can find database samples.
You can try if a formula like:
make a bit faster recalculations, avoiding calculate the VLOOKUP() when there is not value to find.
what's the result? Is it bug or not? Maybe you can try to sort data, then vlookup should be faster.
Maybe it's the same problem than here https://bugs.freedesktop.org/show_bug.cgi?id=79892, a pain.
I'm going to close this bug as duplicate of bug 79892. Symptoms looks similar. There is not test file in this bug report, we cannot investigate more. You can revert status to Unconfirmed if you have additional informations. You can try using vlookup on sorted data or try suggestions from this link https://fastexcel.wordpress.com/2012/03/29/vlookup-tricks-why-2-vlookups-are-better-than-1-vlookup/ (it's for excel but maybe helps on LO too).
*** This bug has been marked as a duplicate of bug 79892 ***