huge pageview and query problem (10 million/day) page view

[Eþref DURNA]

Hello,
We have a web site which have 10 million page views in a day.
We create a banner system.
The web page will call the banner.com at the server side and gets the banner
data
the requested url will be like this

http://banner.com/GetBannerFromUrl.aspx?url=http://mypage.com

or there could be pages which will call this system with keywords.
like
the request will be
http://banner.com/GetBannerFromKeyword.aspx?keyword=love

the problem we have very huge page views will run this application minimum
at 5 web servers.

Using application cache could couse memory problem chose we have thousands
of different web pages.
and we do not want to query the database each time

My problem is which cache problem is best for us? best for performance
1. SqlCacheDependency
2. SqlCache[""]
3. Application[""]
4. Outputcache(server,Client,etc..)

I m oped to any ideas


Thanks for your help from now

 

[Robbe Morris [C# MVP]]

Why are you doing the banner determination at runtime?
Why not follow google's lead and create an index
of your content and pre allocate ads to urls?

Just run your indexing job regularly.