Re: Performance Bottleneck

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance Bottleneck
Date: 2004-08-05 06:40:35
Message-ID: opsb8x5xk3cq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Apache processes running for 30 minutes ?.....

My advice : use frames and Javascript !

In your webpage, you have two frames : "content" and "refresh".

"content" starts empty (say, just a title on top of the page).
"refresh" is refreshed every five seconds from a script on your server.
This script generates a javascript which "document.write()'s" new entries
in the "content" frame, thus adding new records in the upper frame.

Thus, the refreshing uses a new request every 5 seconds, which terminates
very fast, and does not hog an Apache process.

Turn keepalive timeout down.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jesper Krogh 2004-08-05 07:08:48 pg_dump performance?
Previous Message Martin Foster 2004-08-04 16:36:45 Re: Performance Bottleneck