DelphiFAQ Home Search:
General :: Web publishing :: about DelphiFAQ


This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

Performance Issues on this Web Site

I think I found a real issue (and it is repaired)

Every time someone views any page with comments, at the bottom there's the yellow box where they can add a comment.

So far so good.

That yellow box contains the estimated city/ country and flag of the remote user based on the ISP.

That means for every page view the database was queried to find the location, based on the IP number. This is very wasteful, considering that people read much more often than they write a comment.

I changed it now.

The location is not obtained until the user starts some activity in the yellow box.

I monitored the database's CPU load and it's a lot better now.

This should further help with the performance.

Generated 4:01:39 on Oct 29, 2020