Performance Issues on this Web Site

9 comments. Current rating: (2 votes). Leave comments and/ or rate it.

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.

Comments:

2010-01-20, 17:20:07

JG in CARLSBAD from United States

someone please contact me on how to remove 3 comments w/ pictures that i put on the site. //thank u

2010-01-20, 23:47:45   (updated: 2010-01-20, 23:52:29)

DOC from United States

JG in CARLSBAD from United States, You can email Admin: (ptiemann_2000@yahoo.com) Request him remove your posts. Give him a thread name, date, time, and page number. A link to the page your postings are on would be good also. Regards, DOC

2010-01-30, 12:39:19

anonymous

On the page of Micheal Albert he posted comments about me and added my grandson picture as well as mine after discovering him on this site I will like the information removed.I wanted to find out how can this happen. You only blotted out his face on that picture.

2010-01-30, 16:48:58

anonymous from United States

your photo id is not working here

NEW: Optional: Register   Login Email address (not necessary): Rate as Off-topic Very Helpful Helpful Ok article Not useful Very bad	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option, or post under a registered account.
	Show city and country Show country only Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:
Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material. Add a picture: