YAFLogo

tommy382
  • tommy382
  • 100% (Exalted)
  • YAF Commander Topic Starter
11 years ago
I have a relatively weak server (dual core VM, 3GB memory) hosting a few web apps but there is only 2 with relatively high traffic: my custom web app and YAF each having about equal traffic. I noticed the CPU and memory usage is always high on the server. I decided to take down the YAF forum for a few minutes and see what happen. Oddly, the resource usage came down a lot (less than 15% vs 80+% before). By "resources", I specifically mean the CPU usage by process sql server and this process also used 2GB of memory (max memory for a 32-bit process).

I compiled YAF in debug mode to try to identify which part result in high database usage. I noticed that these 2 SP are not cached and hence constantly take up time each page refresh: yaf_forum_listread and yaf_message_getallthanks. See complete listing below.

Not sure what "listread" does but I think "getallthanks" can be cached for maybe 5 minutes? I really don't need up-to-date thanks list if it slow down the app. Anyone goet an idea on how to lower the resource usage? I tried not showing the date on the thanks but that doesn't help much.

Snapshot 1:

[dbo].[yaf_prov_getuser]: 0.003

[dbo].[yaf_smiley_listunique]: 0.009

[dbo].[yaf_forum_listread]: 0.421

[dbo].[yaf_forum_listread]: 0.003

[dbo].[yaf_forum_listread]: 0.005

[dbo].[yaf_forum_listread]: 0.145

[dbo].[yaf_forum_listread]: 0.002

[dbo].[yaf_forum_listread]: 0.002

[dbo].[yaf_forum_listread]: 0.012

[dbo].[yaf_topic_latest]: 0.011

[dbo].[yaf_active_stats]: 0.001

[dbo].[yaf_prov_getuser]: 0.002

Snapshot 2:

[dbo].[yaf_topic_info]: 0.000

[dbo].[yaf_forum_list]: 0.000

[dbo].[yaf_forum_listpath]: 0.000

[dbo].[yaf_post_list]: 0.025

[dbo].[yaf_message_getallthanks]: 0.732

[dbo].[yaf_message_gettextbyids]: 0.006

[dbo].[yaf_prov_getuser]: 0.002

[dbo].[yaf_buddy_list]: 0.001

[dbo].[yaf_active_listtopic]: 0.001

[dbo].[yaf_watchtopic_check]: 0.000

[dbo].[yaf_prov_getuser]: 0.003

[dbo].[yaf_active_list]: 0.002

Sponsor
Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
11 years ago
Thanks for the information. All modified in v1.9.5.
tommy382
  • tommy382
  • 100% (Exalted)
  • YAF Commander Topic Starter
11 years ago
Anyway to take those changes and apply to 1.9.4 now or that is too hard to merge the diffs?
Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
11 years ago
v1.9.5 was going to be released today... but I'm still encountering a few issues here on this server, so I'm doing some more tweaks. Either way, you don't have to wait long. 🙂
Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
11 years ago
tommy382 wrote:

Anyway to take those changes and apply to 1.9.4 now or that is too hard to merge the diffs?

They would not be simplistic to merge, no.

tommy382
  • tommy382
  • 100% (Exalted)
  • YAF Commander Topic Starter
11 years ago
Oh nice, I'll wait for it. Thanks. Any pointer to the list of new features/bug fixes in 1.9.5?
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
11 years ago
tommy382 wrote:

Oh nice, I'll wait for it. Thanks. Any pointer to the list of new features/bug fixes in 1.9.5?

Here is a list of whats new

http://www.watchersnet.de/yaf/WhatsNew.html 

tommy382
  • tommy382
  • 100% (Exalted)
  • YAF Commander Topic Starter
11 years ago
Thanks for the link, looks great. Is it an RC1 or a final version? I recalled 1.9.4Final just came out recently? Very nice to see quicker release interval :o)
Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
11 years ago
tha_watcha wrote:

tommy382 wrote:

Oh nice, I'll wait for it. Thanks. Any pointer to the list of new features/bug fixes in 1.9.5?

Here is a list of whats new

http://www.watchersnet.de/yaf/WhatsNew.html 

Excellent list there....