> From: wicket0123 [mailto:[EMAIL PROTECTED]
> [W]e want every request to be processed within 25
> millisecods.
[...]
> 2. Ad server process the request which include app. code and
> talking to DB
Your database communication, queries and data will have to be very, very
heavily optimised if you want to hit this target - or you'll need some heavy
iron to run it.
How large is the dataset on which you're working? Can you simply load it all
into working memory? Looking up data in memory is typically thousands to
hundreds of thousands of times faster than running a database query. If it's
only a few gigabytes, you may well find it's cheaper to spend on adding RAM to
your cluster than on solving the problem any other way!
- Peter
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
