On Sun, 12 Jul 2009, Shawn J. Goff wrote:
> On Sun, 12 Jul 2009 19:31:31 -0400 (EDT)
> Eben King <eben01@verizon.net> wrote:
>
>> I have an 1800+-line spreadsheet in OpenOffice Calc. Each line has a
>> few calculated cells, and then there are two more pages with ~100K
>> comparisons each. There are also three graphs. It totally can not
>> handle a dataset of this size. I'm talking lots of memory (2 1/3
>> GiB), the system's swapping like mad, and everything's laggy. Is
>> there another spreadsheet I can use, or maybe some techniques to make
>> it usable with large datasets?
>>
>> I have a log of 52000+ points (and growing) that I graph in gnuplot.
>> It takes about 12 MiB RAM and 0.7 seconds to draw the plot, so it is
>> possible for a program to be miserly with RAM and runtime at the
>> expense of interface.
>
> I've had the same problem in the past. My solution was Excel. Sheets
> that will completely hang your system in OO.o will be like nothing in
> Excel; it's crazy.
I guess that's one excuse for runing Windows. At least it's sandboxed in a
VM. Thanks.
-- -eben QebWenE01R@vTerYizUonI.nOetP royalty.mine.nu:81"windows seems to have stupidity buil[t] into it." -- sobriquet on a.o.l. ----------------------------------------------------------------------- This list is provided as an unmoderated internet service by Networked Knowledge Systems (NKS). Views and opinions expressed in messages posted are those of the author and do not necessarily reflect the official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 20:31:08 EDT