John Richard Smith wrote:
> > It is reasonable to suspect memory -- I guess the 21 seconds to
> > load the existing data (and 280 days) gives us a hint that there is
> > a large amount of data involved, but it's only a hint -- I think we
> > need to know a little more:
I still don't really have an idea how much data you have in each
spreadsheet -- here's a list of what I think I know and what I don't
know:
* You have multiple spreadsheets, each in its own file
* Each spreadsheet has:
* 12 columns of data about one stock -- I'm guessing one or two
columns contain something like the date and time, the other 10 or 11
columns contain numbers. Is each column filled for each row?
* An unknown number of rows -- how many rows total for 280 days?
How many rows added per day?
> I don't know how eazy it is to transfer data collated
> from say kspread to say gnumeric, or what ever, and if I have to
> start from scratch that is a decision not taken lightly.
There should be features to help such a transfer -- Excel and Lotus have
them, not sure about Gnumeric and Kspread. It's probably not to be
taken lightly, except maybe one or two spreadsheets on a trial basis.
I'm wondering if there is something about Kspread that uses much more
space than Gnumeric/Excel/Lotus for similar amounts of data, or do you
just have a very large amount of data?
> I think LM8.2 has
> it as standard issue, correct me if I'm wrong. Maybe I ought to
> install it and find out what it is about.
This would be a good thing to do if you are interested, but I suspect we
should concentrate on the spreadsheet issue first.
> PS, I did a KDE Control Center - info - memory
> nice visuals on memory,
> Loaded kspread , loaded a file and when finised and before
> doing anything with it it said :-
>
> Total free + swap = 65%
> uased = 31%
> Physical used +shared = 47%
> buffer = 24%
> cashed = 22% total 94%
> virtual free swap = 95%
>
> Looks as though I'm about out of physical memory. Don't it ?
I don't know -- I always have trouble interpreting Linux memory usage
statistics, particularly with the party line "unused memory is wasted",
etc.
If you really want to check on memory usage, I'd suggest you:
* reboot
* run free from a command line before you start anything (or most
anything) else -- "record" the numbers
* start kspread, run free, record the numbers
* open one of your spreadsheets, run free, record the numbers
Post the numbers here.
Do you typically open multiple spreadsheets at the same time, or do you
open one, do your thing, and close it before opening the next?
Randy Kramer
Want to buy your Pack or Services from MandrakeSoft?
Go to http://www.mandrakestore.com
