Hello, I have been working a bit on performance related calc problems for 3.5.
I have at least one item left for 3.5: for nearly every undo step we create a full copy of the whole document. For 3.5 I planned to improve the undo code for sheets that means that we no longer copy every sheet to an undo document which is insane. If I have a good idea i might as well have a look at the undo code for a single sheet. I hope that there is a better solution than to copy the whole content of a sheet to a new sheet. Then we have of course a little problem with columns. We create for every sheet 1024 ScColumns and ScAttrArray even if we don't need them which needs some memory. I think I did some profiling and a single sheet needs about 150kB on a 64bit computer. These are at least two problems I know, but we have for sure several other problems too. Regards, Markus 2011/7/27 Kevin Hunter <hunt...@earlham.edu> > At 6:07am -0400 Wed, 27 Jul 2011, Michael Meeks wrote: > >> On Wed, 2011-07-27 at 16:12 +0700, Samphan Raruenrom wrote: >> >>> Is there any work on LibreOffice to reduce memory usage of >>> LibreOffice Calc on large spreadsheets? >>> >> >> but IMHO -the- fundamental design problem with calc, is something >> quite banal - the concept that a spreadsheet is built from cells: >> without breaking that basic misconception I don't think we can do >> any of the really interesting space / time optimisations we need to >> do. >> > > Can you elaborate a little on this fundamental design flaw? As a naive and > unfortunately focused elsewhere personality, I don't immediately know of a > better model for creating a spreadsheet. Is it "just" a problem of > sparsity? Or is there a much more sophisticated method for memory sharing > of various similar cell attributes, perhaps analogous to CSS? > > Thanks, > > Kevin > > ______________________________**_________________ > LibreOffice mailing list > LibreOffice@lists.freedesktop.**org <LibreOffice@lists.freedesktop.org> > http://lists.freedesktop.org/**mailman/listinfo/libreoffice<http://lists.freedesktop.org/mailman/listinfo/libreoffice> >
_______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
