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