Le vendredi 02 octobre 2009 à 04:35 -0400, ken a écrit : > I have two questions. Both pertain to a systems monitoring project I'm > developing for a college I work for. We want to monitor two linux > servers. Data (on mem, disk, cpu, etc. usage) will be collected every > ten seconds. This will then be graphed to show what's been going on > with the systems for various periods of time... like up to three weeks. > So this will be a lot of rows and columns. A piece of data every ten > seconds over three weeks comes close to 181,440 pieces of data. Let's > call this 200,000 rows. Multiply this by, say, ten data items each for > memory, swap, disk, and cpu and we have 8M data points, or cells. The > best info I got from google (thus far) was 2005 info which stated, > "GNUmeric could accept more than 256 columns and more of 65000 rows > (needs to be re-compiled)." Does anyone have better, more recent info > about gnumeric which would indicate that it could or could not handle > 200,000x40 cells? Better yet, what are gnumeric's data-holding capacities?
Latest release (1.9.13) supports large sheets provided your computer has enough memory. The sheets size can be changed at runtume, so you don't need a recompilation anymore. You can have up to 16M rows, so it will be enough for your needs. Just I don't really know how fast gnumeric is with very large sheets. Of course, 1.9.13 is a devalopment version, but it seems fairly stable, and we should have the next stable (1.10.0) within three months or so. > Secondly, users will query the database via a web form, which, once > submitted, produce a variety of graphs. Can gnumeric produce its graphs > as a separate image file suitable for insertion into a web page...? > like a jpeg or png file? And, if so, could those image files contain > borders noting, e.g., the days and hours along the x-axis and > percentages on the y-axis? Formats available for axis labels are the same that you can have in a sheet cell. Recently there were some enhancements for axis labelled as dates, so I suppose it should work for you. > Of course the functionality I'm searching for would likely be more > readily found in a database app, like MySQL, but I've been using > gnumeric for a long time (though not its graphing capabilities), so am > more comfortable with it. If it provides the functionality I'm looking > for, then I can feel okay about bending the theoreticals. > > > TIA for your expert replies. > _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
