• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

At last, Similar Threads is a reality! (1 Viewer)

Jon

Access World Site Owner
Staff member
Local time
Today, 07:46
Joined
Sep 28, 1999
Messages
3,676
Welcome to the new Similar Threads feature. Please note, I am monitoring the page load times while using this add-on and if it adversely effects them, I will remove it. Elastic Search is supposed to help with this sort of thing but I will be doing experiments to ensure all is good.
 

Jon

Access World Site Owner
Staff member
Local time
Today, 07:46
Joined
Sep 28, 1999
Messages
3,676
Ok, I'm noticing it is hammering the backend with searches, which pushes up the CPU usage, which has a slight impact on page load times. The main reason is the guests. I could always turn it off for them and leave it for logged in members. It all just depends on how useful people find it.
 

Jon

Access World Site Owner
Staff member
Local time
Today, 07:46
Joined
Sep 28, 1999
Messages
3,676
I've disabled Similar Threads for guests. Keep an idea for how good the recommendations are in the Similar Threads widget. It they are no good, I will get rid of it.
 

jdraw

Super Moderator
Staff member
Local time
Today, 03:46
Joined
Jan 23, 2006
Messages
13,369
Sound good Jon. I have found Similar Threads useful in the past and have encouraged posters to read same for ideas. (y)
 
  • Like
Reactions: Jon

Jon

Access World Site Owner
Staff member
Local time
Today, 07:46
Joined
Sep 28, 1999
Messages
3,676
Ok guys, I am removing the Similar Posts for a while as it is hitting the speed due to a large number of mysql queries. If you really think it is useful, there is always the future option of only showing it to logged in users. That would have little impact on the server and keep the site speed zippy.
 

jdraw

Super Moderator
Staff member
Local time
Today, 03:46
Joined
Jan 23, 2006
Messages
13,369
Seems reasonable. I have pointed a few people to it in the last few days. I think it's useful, but if it interferes with speed generally, then restricting it to logged in users is understandable.
 

Jon

Access World Site Owner
Staff member
Local time
Today, 07:46
Joined
Sep 28, 1999
Messages
3,676
Once I get all my speed optimisations in place I will revisit this issue.
 

isladogs

CID VIP
Local time
Today, 07:46
Joined
Jan 14, 2017
Messages
13,948
It is a very useful feature and very much hope that it will be restored soon.
Even if it does slow down the site slightly, the forum is now much faster than many other forums I visit.
 

Jon

Access World Site Owner
Staff member
Local time
Today, 07:46
Joined
Sep 28, 1999
Messages
3,676
We can bring it back easily for logged in members. That will hardly hit performance at all. When we have 400 guests, each time they come to the site there is a query that has to be done. With logged in members, there are only usually about 20 people logged in at any one time, and that would have very little impact. The fact you like it suggests that it will probably be coming back.

I have implemented a memcached cache, but my page load times seem to have slowed! This is very frustrating!
 

Jon

Access World Site Owner
Staff member
Local time
Today, 07:46
Joined
Sep 28, 1999
Messages
3,676
You're welcome. I want to give you guys as much as I can to make it a nice place to hang out. I am so pleased the old server downtime and slow speed issues are gone. We have the fundamentals in place, so now it is about the tweaks.
 

zeroaccess

Active member
Local time
Today, 02:46
Joined
Jan 30, 2020
Messages
607
Ok guys, I am removing the Similar Posts for a while as it is hitting the speed due to a large number of mysql queries. If you really think it is useful, there is always the future option of only showing it to logged in users. That would have little impact on the server and keep the site speed zippy.
I think a good compromise would be to only show it on click of "related posts".

That way it isn't running queries for those doing casual browsing.
 

Jon

Access World Site Owner
Staff member
Local time
Today, 07:46
Joined
Sep 28, 1999
Messages
3,676
There isn't that option in the software.
 

MickJav

It wasn't me
Local time
Today, 07:46
Joined
Nov 28, 2005
Messages
2,202
Similar threads have helped me a number of times when a thread doesn't quite give the answer you want you can check the similar threads where you can sometime pull a solution together.

Mick
 

Users who are viewing this thread

Top Bottom