Forums

ProWeb

Member

Registered: 2008-05-17

Posts: 46

How To Cache "Recent Posts"

I have a very large PunBB forum and members always get the following error:

An error was encountered
File: /home/account/public_html/forum/search.php
Line: 417

PunBB reported: Unable to insert search results

Database reported: Duplicate entry '355925800' for key 1 (Errno: 1062)

It is one of the top 5 pages visited on the entire site, to put into perspective, it gets viewed on average 5 times every minute of every day... or probably more like 30 times a minute during peak times and 1 time a minute in the middle of the night.

I started to wonder if I should create a cache of that page which would be updated every 10 - 15 seconds.  I've already cut the time from 24 hours to just 3 hours in an attempt to make it more efficient since members are viewing it so often.

Any thoughts on how to:

1)  Resolve the error message
2)  Optimize the query
3)  Cache the results

Thanks in advance for any pointers!