[Libreoffice-bugs] [Bug 67071] VLOOKUP between two files is slow if both files are open

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=67071

Markus Mohrhard  changed:

   What|Removed |Added

 Status|ASSIGNED|RESOLVED
 Resolution|--- |FIXED
   Assignee|libreoffice-b...@lists.free |markus.mohrhard@googlemail.
   |desktop.org |com

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67071] VLOOKUP between two files is slow if both files are open

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=67071

--- Comment #21 from Commit Notification 
 ---
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=c8ad72703b74b7338c5f8dd1fe0275822b1e45f0

don't fill the matrix cell by cell, tdf#67071

It will be available in 5.2.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67071] VLOOKUP between two files is slow if both files are open

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=67071

--- Comment #20 from Markus Mohrhard  ---
Actually with a third patch I'm able to go to asymptotically O(1). So it is
after the first cell which takes a second nearly instant.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67071] VLOOKUP between two files is slow if both files are open

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=67071

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:5.2.0

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67071] VLOOKUP between two files is slow if both files are open

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=67071

--- Comment #19 from Commit Notification 
 ---
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=f18cb2c196cc5b643b9832dfca1d940b82c832b0

single element access is really slow in mdds, tdf#67071

It will be available in 5.2.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67071] VLOOKUP between two files is slow if both files are open

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=67071

Markus Mohrhard  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED

--- Comment #18 from Markus Mohrhard  ---
I have two patches that bring the performance back to somewhat acceptable
levels. I'm down to about a second per cell in my own build.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67071] VLOOKUP between two files is slow if both files are open

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=67071

--- Comment #16 from Markus Mohrhard (retired)  
---
The fix for this will depend on https://gitlab.com/mdds/mdds/issues/5

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67071] VLOOKUP between two files is slow if both files are open

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=67071

--- Comment #15 from Emersson Augusto Suarez Ortiz  ---
Hello to everybody, I am agree that this is a huge bug for CALC, I'm using
LibreOffice 5.0.1.2 and earlier form the 5 series, and Vlookup in a big file,
for example 200 hundred thousand rows to enrich a one thousand rows file, in
Ubuntu 14.04, it block the PC, get 100% CPU usage, 100% of my 4GB RAM Memory
and 100% of my 4GB Swap Memory.

I also agree that this is a disadvantage of Calc vs MS Excel, cause now Excel
can easily handling a 1 Million rows file and enrich the same 1 thousand rows
file, and maybe the reason is that legal or not, the most used program is
Excel, and I turned very upset for this bug. Just now I have to change to
windows for handling my problem·

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs