Chuck, If the UV box is running XP Pro, 2Gb is your upper RAM limit. The OS will take 3 Gb on the box but only address the first 2 Gb it finds.
Run a dual core AMD processor with some nice fast SCSI HDD. RAID 10 is fast but expensive. A pair of large drives mirrored will do the trick if the DB doesn't grow too fast. Andy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Tuesday, 13 March 2007 10:57 a.m. To: [email protected] Subject: Re: [U2] How much RAM is too much Bob, I can't change the SQL boxes or the network. The only place I can help myself is in the layout for the new box. The new box will have UV, a tiny Delphi program which reads from UV (via UniObjects), and two tiny Delphi programs which do massive SQL selects over the slow network. The thing is, I can say "2GB" memory or "4GB" memory, but I can't say 'a lot'. I need to know if there is an upper limit after which the system stops benefiting from more money being thrown at it. - Chuck "64K" Barouch Bob Woodward wrote: > 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/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
