I would refrain from Microsoft SQL (http://slashdot.org/articles/02/05/22/1312211.shtml?tid=109) or any Microsoft products for that matter (http://www.eweek.com/article/0,3658,s%253D701%2526a%253D26875,00.asp)
"A senior Microsoft Corp. executive told a federal court last week that sharing information with competitors could damage national security and even threaten the U.S. war effort in Afghanistan.... ---->He later acknowledged that some Microsoft code was so flawed it could not be safely disclosed<----" Randy Kramer said: > John Richard Smith wrote: >> I use Kspread to calculate daily moving averages and when I load the >> relevant file it takes 21 seconds to load all the existing data, and >> there are ,in addition to the current days input, 5 moving averages to >> calculate for each index. Currently I have 280 days of data and >> building. >> >> I have 250Mb of SDRAM on this particular machine and ample swap >> partition. The processor is an Int3 500Mhz. >> >> I am beginning to get cursor lock. Is this likely due to lack of >> memory. It nearly always occurs during the calculation of a cell sum. >> I am no longer able to sweep down a whole line of cell blocks like I >> used to be able to do.It just refuses to. >> >> I suspect memory,and have an alternative much powerful machine ready >> to take over, but would appreciate the benefit of your vastly greater >> experience, before I do so. > > 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: > > How big is your spreadsheet, in rows and columns, and or in daily data > points and different "subjects". (Are you calculating moving averages > for stocks, for example? If so, how many stocks are on this > spreadsheet? How far apart are the data points -- one every second, > one every 15 minutes, ...? Is data collected 24 hours a day, 8 hours a > day, or ...? Etc. Or, how much total data is stored for a day?) > > Until we hear back from you, I wonder if you ever tried another spread > sheet, any of, for example Gnumeric for Linux, or Excel, Lotus, or > whatever on Windows? Problems with those also? > > As an aside, a spreadsheet is not usually the best choice for dealing > with really large amounts of data -- you may want to begin to think > about a migration to a database, like MySQL, Postgres, Access, > Microsoft SQL, or whatever. > > Randy Kramer -- Never do anything against conscience even if the state demands it. - Albert Einstein (1879-1955)
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com