https://bugs.freedesktop.org/show_bug.cgi?id=72741
Priority: medium
Bug ID: 72741
Assignee: [email protected]
Summary: UI: Sort performance ~17 times slower than version
4.0.6.2
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
The time it takes to do even a simple single-column sort of my (attached)
spreadsheet takes ~17 times longer on version 4.1.3.2 as compared to version
4.0.6.2.
The spreadsheet contains 13 columns by 62,712 rows of "General" formatted cells
that contains plain alphanumeric values.
I initially noticed the performance problem when multi-column sorting using
Data>>Sort..., but then noticed the problem when sorting just one column. So, I
devised a simple single column test case by adding a 14th column of =RAND()
formulas to my spreadsheet making it easier/faster to test.
Using the 'Sort Ascending' toolbar button to sort the random column yields the
following times on my HP Envy dv6 AMD A8-Quad-Core Laptop w/6GB RAM (on
openSUSE 13.1 64-bit):
LibreOffice_4.0.6_Linux_x86-64: 18 seconds
LibreOffice_4.1.3_Linux_x86-64: 308 seconds
Steps to reproduce:
1. Download and install these two packages from
http://www.libreoffice.org/download/ :
LibreOffice_4.0.6_Linux_x86-64_rpm.tar.gz
LibreOffice_4.1.3_Linux_x86-64_rpm.tar.gz
2. Download the attached sample spreadsheet (62krows.obs)
3. Execute the following command to load the spreadsheet with 4.0.6.2:
/opt/libreoffice4.0/program/scalc 62krows.ods
4. After the spreadsheet is fully loaded, select a cell in column A ("Rand").
5. Using a "stopwatch" (or clock with second hand) measure the time it takes
for the sort operation to complete; start timing when you click the "Sort
Ascending" button in the toolbar. Record the elapsed time when the operation
completes.
6. Execute the following command to load the spreadsheet with 4.1.3.2:
/opt/libreoffice4.1/program/scalc 62krows.ods
7. After the spreadsheet is fully loaded, select a cell in column A ("Rand").
8. Using a "stopwatch" (or clock with second hand) measure the time it takes
for the sort operation to complete; start timing when you click the "Sort
Ascending" button in the toolbar. Record the elapsed time when the operation
completes.
Current behavior:
LibreOffice_4.0.6_Linux_x86-64: 18 seconds
LibreOffice_4.1.3_Linux_x86-64: 308 seconds
Expected behavior:
LibreOffice_4.0.6_Linux_x86-64: 18 seconds
LibreOffice_4.1.3_Linux_x86-64: 18 seconds (or less)
Operating System: openSUSE
Version: 4.1.3.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
