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/
