Wow, very disappointing! I did some testing on your 57 kb file on KSpread 1.1 on Mandrake 8.1, on a 700 MHz machine (AMD) with 256 MB of memory. (With about 280 rows of 12 columns each, I'm guessing about half the cells actually contained data (numbers).)
The file took around 30 seconds to load. It was easy to convert the file to Gnumeric and comma delimited format. I don't have Gnumeric on the machine so I couldn't try it. I took the comma delimited file to my Windows 95 machine -- 300 MHz., 64 MB memory, Excel 97. Loaded the file into Excel, saved it as a native Excel file (.xls) -- quit Excel, opened Excel, loaded the .xls file in about 1 second. I noticed you had some colors applied to the columns, I did not apply colors to the Excel file -- if I get ambitious I might try that and see how much that affects the load time. I did try something else -- I did try two other things: * I tried importing the comma delimited file back into KSpread, and it was significantly faster. It took about 10 seconds of machine time to load up, but this consisted of two 5-second periods -- an intermediate menu comes up halfway through the load to allow you to specify any necessary options -- you can just hit enter. * I saved the imported comma delimited file from KSpread as a .ksp file, and then loaded it -- it took about 14 seconds, and the difference between that and the original 30 seconds may be an indication of the extra time due to colors. Anyway, I'd call it a disappointing performance by KSpread. OK, I went back to Excel and applied colors to every two column group, saved, exited Excel, restarted Excel, then reloaded the .xls file. Still under 1 second! I'm taking the liberty of sending this back to the list for other's information -- IIRC, it was on the newbie list. Randy Kramer John Richard Smith wrote: > Attatched I send you one kspread file, kspft30.ksp, which is > currently 57.0kb, not exactly huge it it, kspread seems to create a > backup file called ~kspft30.ksp I guesss this is a safety feature ? > > Since each file is quite small I find it just incredible that loading > one single file of this size demands such an enormous amount of > memory. Remenber I have 250Mb of SDRAM. > > Currently I have 5 such index files stashed in a home directory. > I select them in the customery fashion in kspread one at a time, > update them and then, save that file in that home directory, and > again `save as' , an identicle file on a floppy for backup. I then > exit that file altogether and select another file from the home > directory and repeat the exercise again for each index held . > > I don't feel that this kspread programme and the individual index > file should clog up my memory to such an extent. > > I haven't sent this email to the list because of the file attatchment.
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
