[phpOpenTracker-general] very slow response for 1st hit when using phpopentracker
Richard Green <[email protected]> Wed, 15 Mar 2006 11:16:51 +1100
| Newsgroups | gmane.comp.web.phpopentracker.general |
|---|---|
| Message-ID | <[email protected]> |
Hi Using postgresql 8.1 for my database back end (optimized by increasing buffer storage to 128MBytes). Hardware is good - SCSI drive, lots of RAM, no swapping. My site takes several seconds (16s for php to genereate the HTML for a page) to respond to the first hit to my site (similar for both directly call to logging function and when using web bug). For subsequent hits to the site, the overhead is minimal (e.g. 0.054s for php to generate html for a page). I think this relates to sessions, or the SQL query that takes place when there is a new session. Restarting my browser (thus session cookie is removed) causes the problem to repeat. - Has anyone seen a similar problem? - Does anyone have any further optimization ideas? Thanks and regards Richard Green