Re: [libreoffice-users] Re: 64 bit

Hi :)
2 possible ways to make it go faster
Toolos - Options - Memory
and just ramp everything up that looks vaguely relevant.  I tend to take
things up to at least 20Mb but perhaps even higher like 200Mb might be
better.

Also which format are you using?  If native Ods then that should be a lot
faster and better than MS's formats and especially better than the one with
X on the end, such as .XlsX

Third is to use a dedicated spreadsheet tool for hefty jobs like that.
 Gnumeric knocks the spots off Excel and leaves it far behind in your
rear-view mirror.  Again it's best if using it's native Ods format that is
also native to LibreOffice.  However even if your file is in XlsX then
Gnumeric can still open it
https://projects.gnome.org/gnumeric/


It's not particularly unusual to have MS Office, LO (or AOO) and Gnumeric
all on the same machine, perhaps with Scribus or some other proper DTP in
addition.  Office Suites are meant to be a "jack of all trades" but not
necessarily master of any.  While Writer and Draw are more like DTPs than
Word they are still not dedicated to that sort of thing and getting a
proper tool such as Scribus or some LaTeX package takes it to the next
level.  Similarly with Gnumeric.  It doesn't have to worry about
side-issues so it can focus on purely spreadsheet functionality.


Non-OpenSource tries to make 1 monolithic program to do everything but in
OpenSource world we are more into the idea of having different specialist
programs co-operating with each other.  LibreOffice is quite unusual in
that regard because it combines several different sorts of things but that
usually works out superbly in LOs case.  However, there are times when it's
best to find the specialist tool instead
Regards from
Tom :)




H


On 7 November 2013 05:44, Denis Navas Vega <denis.navas@gmail.com> wrote:

> El 2013-11-05 05:51 p.m., Pedro escribió:
>
> > krackedpress wrote
> >
> > > The next thing people will insist on is LO being designed to run on all
> > > 2, 4, 6, or even 8 cores of the CPU at the same time to make it even
> > > faster.
> >
> > Do you really think it makes sense that Calc and Base are not prepared to
> > use all the computing power available?
> >
> > Why do you think TDF and AMD are trying to bring GPU calculation to LO?
> > Because Calc (I haven't even tried Base...) is absurdly slow!
> >
> > A heavy calculation spreadsheet I have takes 50 "seconds" to open in Excel
> > 2010 and takes more than 10 *minutes* to open in Calc! (both 32bit
> > versions)
> >
> > No wonder Kohei Yoshida (one of, if not *the* main Calc developer) said
> > recently (August 2013): " You can’t compare Calc with Excel yet. They are
> > still miles ahead of us."
> >
> > When Calc is able to use all cores and threads and eventually 64bit
> > operations then it might be on par...
> >
> > Why do you assume the OP isn't doing number crunching?
> >
> >
> >
> > --
> > View this message in context: http://nabble.
> > documentfoundation.org/64-bit-tp4081444p4081605.html
> > Sent from the Users mailing list archive at Nabble.com.
> >
> >  I won't insist on 64 bits, because I use machines that work on 32 bits,
> but the affirmation that Excel is more faster than Calc is true.  I have
> been working the last six weeks with databases from a census, and can
> confirm the following:
>
> -- Calc is really slow with lots of data.  When the book requires more
> than 384 MB of memory, it slows down to an impractical speed.  Days ago, I
> spent the whole day building a crosstab.
>
> Open/Save is really slow and does not help a different file format to
> speed up things.
>
> Another difficult thing, is with sorting and filtering.  Is slow too.
>
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted