Oops.. accidently clicked Send before writing anything... Sorry. Comments
follows.

2007/4/30, Johnny Andersson <[EMAIL PROTECTED]>:

2007/4/30, NoOp < [EMAIL PROTECTED]>:
>
> On 04/28/2007 03:57 PM, Johnny Andersson wrote:
>
> >
> > I can't see why it wouldn't be "safe". Depends on what you mean by
> > "safe" I guess. 128 MB? Well, it will probably work, but it might be
> > very slow. I tried to run OpenOffice.org 2.0 a few months ago on my
> > old machine (P2, 450 MHz and 320 MB) and it was way too slow for me.
>
> I run OOo [linux] 2.2 everyday on a 450Mhz/256MB and it runs just fine
> for me.  I also run it on 300Mhz/256MB and 650Mhz/256MB machines without
> any problems. That said, I have a customer with a Win2KP 350Mhz/196MB
> machine, and running OOo (or anything else for that matter) on it is
> unbearably slow. The only reason why I've held off converting it to
> linux is that the hard drive is only 3Gb.
>
> I wouldn't recommend 128MB for OOo and would recommend 256MB minimum.
>
> > Now I have a 1,6 GHz laptop with 2 GB and OpenOffice.org 2.2. It
> > doesn't feel slow any more but not fast either.
>
> What OS are you using? A 1.6Ghz/2GB machine should be able to run
> blazingly fast.


Well, I guess I am just sensitive in that case. Right now I have XP SP2 with
some shit going on in the background (anti-virus, firewall, etc).

Opening a 800 kB Calc file (in this case a sxc, since I created it a few
years ago) takes about 20 (TWENTY) seconds. Even longer after a fresh start
of Windows, especially without the quickstarter.

One of the cheets contains about 2200 rows 22 columns. Half of them use
conditional formatting. There are a lot of VLOOKUPs.

Doing autofilter on that sheet with OpenOffice.org 2.2 seems to be
impossible. Actually I started one at 10:38, it's 10:40 soon and I will give
it a few more minutes (although I think that one or maximum 2 second could
be acceptable; 2200 rows and 22 columns is almost nothing).

Wow, it actually finished! At almost 10:43. Almost 5 minutes, at least 4.
This is truly terrible!

I will now redefine the autofilter area to include 65529 rows (the header is
at row 8, so the first 7 lines are not included). Let's see how long it
takes.

Starting filtering at 10:52:00.
Finished filtering at 10:52:25! Strange! Why did it suddenly go much faster?
But 25 seconds is still ridiculously slow.
Seems to depend on what I select in the filter drop down list. I try the
same as I did when it took 4-5 minutes last time:
Starting filtering at 10:54.
Finished filtering at 11:07.
Total time: 13 minutes.

In this case it found 3 rows, I guess it takes some time to hide 65526 rows.

I will now do this manually, using Search and then hide the rows manually
(not one by one, of course):
Starting at 11:17.
Finished at 11:23.
Total time: 6 minutes.

Trying a quicker, but still manual method:
Starting at 11:25.
Finished at 11:27.
Total time: 2 minutes.

Sorry for stealing this thread, once I started to test things I can't
stop... ;)

It would be interesting to know why it takes so long to filter these 2200
rows. Does it hide the filtered rows one by one? maybe I should file a bug
report (asking for a speed enhancement) about this?

Just for my own curiosity, I will now install OpenOffice.org 1.1.5 on this
machine for the first time and try to do the same thing again:

First the case that took 25 s with OpenOffice.org 2.2:
OpenOffice.org 1.1.5: 10 s

Then the case that took 4-5 minutes with OpenOffice.org 2.2:
OpenOffice.org 1.1.5: 10 s

Hm.. it really looks like there is a some kind of Autofilter bug in
OpenOffice.org 2.2, doesn't it?

Of course, when I'm just typing, I can notice no delay of any kind, but I
would be surprised if there was. It's when doing the heavy stuff things
feels slow. When running OpenOffice.org 2.0 on my old 450 MHz 320 MB machine
mentioned above, I could even notice a delay when I was typing! Every
character appeared on the screen maybe half a second delayed or something
like that. Very annoying. If I type fast (which I usually do) I have to sit
and wait for the whole sentence to be completed on the screen if I want to
check if what I typed makes sense, and if it was a long sentence, it could
take several seconds! But again, that was with my old system (which had
Windows 98 by the way, since XP was way too slow for it, I have tried that
too and it only made me mad).

Johnny Andersson



> > About "the other computer", you didn't say anything about it. Is it a
> > newer computer than the P3 1 GHz 128 MB one?
> >
> > It shouldn't matter what computer you use to download it, not much
> > anyway.
> >
> > When downloaded it, if you want a CD to install from, just copy the
> > downloaded file to the CD using your favourite CD burning software.
> > Then put the CD into the "other" computer, double click the file on
> > it and OpenOffice.org will be installed, won't it? I think so anyway,
> > until someone proved me wrong.
> >
> > Johnny Andersson
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>

Reply via email to