Johnny Rosenberg wrote:
I just installed OpenOffice.org 3.1.0 on my Ubuntu 8.10 system. Before
I did that I read about what's new and things like that. It was
interesting to see that they finally did something about at least some
speed issues, so I was looking forward to install it and see if it
feels faster.
However, fixing a few speed issues doesn't necessary mean that there
are no speed issues left, so I tried something that I tried years ago,
which was slow back then. Unfortunately I don't remember HOW slow it
was then and I used another computer then too.
So now I'm asking others to test this too, and tell me if you agree
with me that this could be done a lot faster. If you have Excel, it
would be interesting if you converted it to Excel format and did the
same test in Excel.
Test what? Ok, I'll come to the point.
First download this test document:
http://hem.bredband.net/guraknugen/TestfileAutofilter.ods
It's about 500 kB so it will take some time to download with a slow connection.
Don't worry about what's in the file. Most of the words there are fake
(created with a random name macro also included in that file - you
don't need that macro in this test though).
There are a bit more than 2000 rows and what I want you to do is to
use the autofilter function.
For example I did this:
Click the autofilter button in the ”Till” column, which is column I.
Select the first thing in the list: ”Adindy” (yes, it's a fake word
and means nothing - if it does in some language, it's a coincidence).
This took about 18 seconds on my computer!
Selecting All took about 15 s.
One strange thing is that I tested this again now, after downloading
the file from the address mentioned above, and now it's a lot faster:
8 seconds for ”Adindy” and about 3 seconds for All.
Still, this is only about 2000 rows. 65536 rows shouldn't take more
than a second or so.
And selecting all sheet and then select ”Show” is a lot faster than
then selecting All from the Autofilter thing.
I was going to file a but report (speed issue) about this, but I want
to hear other's opinions first.
1.6 GHz dual core, 2.0 MiB RAM, OpenOffice 3.1.0, Ubuntu 8.10.
Let me get this straight.
You use the autofilter to display all of the "Adindy"
"records" in the file. Is that correct?
It will show 16(?) Adindy "records".
If that is correct, then here is my info;
Dell Inspiron 1525
Win Vista/premium
Pentium Dual Core 2 gig processor, 2 gig ram
With many background software running
including security software,
plus
Thunderbird
My Computer
OpenOffice.org's 3.1.0 help menu system
And the Tested File open
It took less than a two seconds to do what
you said took 8 seconds. This was the slowest
since it took less than a second the first time.
The slowest time was with both the back/forward
arrow buttons displayed, ie. I did and undid
much in my test.
But it did take almost no time, second or less,
to do the "Adindy" thing on my laptop.
Less than 2 seconds slowest and less than the 1 second
mark in the fastest.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
