Issue 69301 - sorting is 10x slower than Excel
Summary: sorting is 10x slower than Excel
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-09-05 22:37 UTC by aziem
Modified: 2017-05-20 11:13 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
I sorted by column H (744.88 KB, application/octet-stream)
2006-09-20 01:06 UTC, aziem 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description aziem 2006-09-05 22:37:16 UTC 
Sorting the same, large spreadsheet is an order of magnitude slower in
OpenOffice.org 2.0.3 than in Excel 2000.  There should be opportunities for
optimization.

Approximate times (Windows 2000, 1GHz Intel CPU):
OpenOffice.org 2.0.3: 12 seconds
Excel 2000: 1.5 seconds

In my case, it's sorting a 40,000x20 spreadsheet by a mostly-blank text column.
 (For my case here, it's generally tolerable, but I imagine it's more serious
for other people.)
Comment 1 gercokees 2006-09-18 14:40:01 UTC 
Hi,
Can you please (if possible) attach the file where this problem occurs?
Thanks in advance...
Besides, i do thank a difference of 12 - 1,5 seconds is realy an issue...
Comment 2 aziem 2006-09-20 01:06:07 UTC 
Created attachment 39258 [details]
I sorted by column H
Comment 3 gercokees 2006-09-25 11:28:46 UTC 
Hi,
I did some tests with the attatched file, and i can confirm that excel is indeed
faster than OOo, so I confirm this issue
Comment 4 frank 2006-09-28 14:39:46 UTC 
Hi Eike,

measured 6 sec for Calc and 2 for Excel2007b2

Frank
Comment 5 ooo 2006-09-28 16:35:38 UTC 
Accepting.
Comment 6 Marcus 2017-05-20 11:13:10 UTC 
Reset assigne to the default "issues@openoffice.apache.org".