On Thu, Sep 29, 2005 at 09:20:00AM +0200, Rafael Montoya wrote: > Ok, there are about 15 concurrent clients inserting and updating data, and > 20 concurrent clients only consulting. > I dont need all data in ram, of course, hehe, but i really have no idea > what's the minimum of ram for having fast answers for about 2000 > transactions in a day. 2000 transactions a day? We were doing over a million per day a few years ago on a dual PII-350 with 256MB of RAM. As far as people are concerned here, that's chicken feed. you might need a little more RAM for the clients but really... > Almost all queries need to read more than 7 or 8 tables each time. > It will work in a Windows 2000 Server. I need to know whats the appropiate > hardware, because im sure its not necessary to buy a powerful server if a > not so powerful one can have a good performance too. I will really > appreciate any help. My suggestion, find a spare server you arn't using, and try it out. That's the only way to be sure... -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
Attachment:
pgpyPQwvyVXNb.pgp
Description: PGP signature
