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@svana.org> 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.