Re: Need for speed

Ulrich Wisser wrote:
> Hello,
> 
> one of our services is click counting for on line advertising. We do 
> this by importing Apache log files every five minutes. This results in a 
> lot of insert and delete statements. At the same time our customers 
> shall be able to do on line reporting.

> I need some ideas how to improve performance in some orders of 
> magnitude. I already thought of a box with the whole database on a ram 
> disc. So really any idea is welcome.

So what's the problem - poor query plans? CPU saturated? I/O saturated? 
Too much context-switching?

What makes it worse - adding another reporting user, or importing 
another logfile?

--
   Richard Huxton
   Archonet Ltd