Ad serving app takes too much RAM

[eluser]rogierb[/eluser]
A decent vps with 7gb of memory should handle a load like that without any problems, that is if your running linux.
What webserver are you using? What database?

Is the 500 error because of the webserver not handling requests fast enough or is de database delaying requests and thus the webserver?

How well is the table indexed?