Okay. I see now. The real benefit would be putting more memory on the SQL boxes. The UV box won't be the bottleneck for your processing ability. It's going to be the slow network and the speed of the SQL systems. For UV, you'll probably get just as much out of 2 gigs as you will 4 gigs, or more. Delphi may benefit from more, I don't know. I would still try to get as fast a network card as you can in the off chance that they want to experiment later on, with the SQL servers. Just make sure it will automatically step down to whatever they are currently using. Of course a fast processor would be good, especially when they start thinking they can put additional applications/services on this new box. But it's hard to control that and almost inevitable no matter where you go.
Anyway, that's my take on what I think is your situation. Take it with a grain of salt but I don't think I'm very far off, if at all. Hope that helps. BobW -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Monday, March 12, 2007 2:57 PM 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/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
