Either I don't understand the implication or the answer seems way too easy. Put a medium size box in the mix with Universe on it to keep it away from the SQL box. Throw as much RAM on the SQL box as the MB will allow and put a couple super fast network cards between the two servers.
Of course I may need a mental reset, too. :-) BobW -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Monday, March 12, 2007 12:52 PM To: [email protected] Subject: [U2] How much RAM is too much All, I need some opinions! I have a client who is willing to spend to put up a nice sized box, but they only want to spend once. Here's what they need to do: run a 4 user copy of Universe, holding a Type 30 file with a mere 200k records. Requests will range from give me one record (average size is under 200 bytes) to give me all records. The catch is that two SQL databases, with criminally slow network connections will be feeding a fresh set of records every hour. I need a recommendation on how much RAM and Processor to throw at the system so that SQL joins (6 levels deep) don't slow down the UniVerse part of the system. The response time has to be obscenely quick (eCommerce for a very, very busy site). All thoughts appreciated. -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
