Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4253
Latest: Ineedsmfhelp
New This Month: 1
New This Week: 0
New Today: 0
Stats
Total Posts: 43242
Total Topics: 7516
Most Online Today: 126
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 116
Total: 116

Author Topic: low performance for logged in user  (Read 8282 times)

0 Members and 1 Guest are viewing this topic.

Offline fondlyPiranha

  • Member
  • *
  • Posts: 27
    • View Profile
low performance for logged in user
« on: June 23, 2016, 12:08:34 am »
Can you help me to understand

what is the reason, that a guest request (eg. open a single cat) is during 0,08 seconds (for 26 requests)
and the same cat opening as logged in user is during 100 seconds (for 30 requests)

which requests is the system performing that the loading time is so long

sometimes i become a timeout from server

is it possible to optimize the system, because it is very strong to manage

this problem is very critical while server load ballance is higher than 5%


Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16428
    • View Profile
Re: low performance for logged in user
« Reply #1 on: June 23, 2016, 07:45:27 am »
Would need to see the queries run.
http://www.simplemachines.org/community/index.php?topic=269695.0


$db_show_debug=true line to your Settings.php

Then see what is gong on when you click that category
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline fondlyPiranha

  • Member
  • *
  • Posts: 27
    • View Profile
Re: low performance for logged in user
« Reply #2 on: June 25, 2016, 03:04:23 am »
ok thanks so i will first look at the debug output myself

the problem not only is while opening a category, also the opening  (and also saving) of some forms like "add new cat", "edit cat" "edit pic" and move pictures operation  are taking a lot of time so that often timeouts appearing

goes to about 180 seconds  (have changes max execution time to maximum 180 sec)

I expect a circulating process because each of this mentioned operations is significantly growing the server load


Offline fondlyPiranha

  • Member
  • *
  • Posts: 27
    • View Profile
Re: low performance for logged in user
« Reply #3 on: June 28, 2016, 02:17:53 am »
Would need to see the queries run.
http://www.simplemachines.org/community/index.php?topic=269695.0


$db_show_debug=true line to your Settings.php




i've added the db_debug output

seems that the db queries are not the reason for the long execution time

is where any debugging tool to checking the executed code for performance problems?




Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16428
    • View Profile
Re: low performance for logged in user
« Reply #4 on: June 28, 2016, 08:11:12 am »
These might be slow but hard to tell for me seems like it is part of some other mod.

SELECT name, description, image, code, prior, after, parse, trim, type, block_lvl, enable, display, view_source
FROM smf_personalized_bbc
WHERE display = 1
ORDER BY name
in .../Sources/PersonalizedBBC.php Zeile 190,welches 9.799E-5 Sekunden bei 157.90746498 Anfragen benötigte.

UPDATE smf_log_activity
SET
   hits = hits + 1
WHERE date = '2016-06-28'
in .../Sources/Subs.php Zeile 3063,welches 0.00017595 Sekunden bei 157.90775609 Anfragen benötigte.

SELECT name, description, image, code, prior, after, parse, trim, type, block_lvl, enable, display
FROM smf_personalized_bbc
ORDER BY name
in .../Sources/PersonalizedBBC.php Zeile 121,welches 7.319E-5 Sekunden bei 157.90868592 Anfragen benötigte.

SELECT id_button, name, href,
   target, link_type, button_order,
   level, id_parent, has_children
FROM smf_menu_items
ORDER BY button_order
in .../Sources/menu_source/resources/main.php Zeile 62,welches 8.702E-5 Sekunden bei 157.90974998 Anfragen benötigte.

Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline fondlyPiranha

  • Member
  • *
  • Posts: 27
    • View Profile
Re: low performance for logged in user
« Reply #5 on: June 29, 2016, 05:53:13 am »
ok now i will attach 2 files

this is the output of a request of the same gallery cat

1. as guest

2. as admin

in the second example it look like the function GetCatPermission from gallery2.php (which is not foreign code i think) is executed 3 times and the db request is done 3 times with the same parameters



Offline fondlyPiranha

  • Member
  • *
  • Posts: 27
    • View Profile
Re: low performance for logged in user
« Reply #6 on: June 29, 2016, 06:03:55 am »
These might be slow but hard to tell for me seems like it is part of some other mod.

SELECT name, description, image, code, prior, after, parse, trim, type, block_lvl, enable, display, view_source
FROM smf_personalized_bbc
WHERE display = 1


ORDER BY name
in .../Sources/PersonalizedBBC.php Zeile 190,welches 9.799E-5 Sekunden bei 157.90746498 Anfragen benötigte.

UPDATE smf_log_activity
SET
   hits = hits + 1
WHERE date = '2016-06-28'
in .../Sources/Subs.php Zeile 3063,welches 0.00017595 Sekunden bei 157.90775609 Anfragen benötigte.

SELECT name, description, image, code, prior, after, parse, trim, type, block_lvl, enable, display
FROM smf_personalized_bbc
ORDER BY name
in .../Sources/PersonalizedBBC.php Zeile 121,welches 7.319E-5 Sekunden bei 157.90868592 Anfragen benötigte.

SELECT id_button, name, href,
   target, link_type, button_order,
   level, id_parent, has_children
FROM smf_menu_items
ORDER BY button_order
in .../Sources/menu_source/resources/main.php Zeile 62,welches 8.702E-5 Sekunden bei 157.90974998 Anfragen benötigte.




Sorry but this 3 requests can't be the problem

this same requests are also executed in guest mode where is not  performance problems


Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16428
    • View Profile
Re: low performance for logged in user
« Reply #7 on: June 29, 2016, 07:36:15 am »
I cant' really understand the attachments.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline fondlyPiranha

  • Member
  • *
  • Posts: 27
    • View Profile
Re: low performance for logged in user <solved>
« Reply #8 on: June 30, 2016, 03:02:18 am »
ok thanks a lot for galleryPro and your great supportPro  ;)

the reason for the mentioned problem is the high amount of categories in our gallery

are where some solutions to do a workaround

for our gallery i've solved the problem myself - thank you for providing me on this way

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
3700 Views
Last post March 18, 2007, 03:42:56 am
by brent38934
20 Replies
15921 Views
Last post May 06, 2010, 06:08:16 pm
by flutter
5 Replies
5285 Views
Last post May 25, 2010, 12:38:36 pm
by Black Viper
2 Replies
3615 Views
Last post September 14, 2012, 03:31:18 pm
by Garth
1 Replies
6006 Views
Last post July 10, 2016, 06:03:08 am
by SMFHacks

+- Recent Topics

is it possible to add support for odysee.com by SMFHacks
March 13, 2024, 10:53:28 pm

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

User Gallery Feature: move / bulk move images by SMFHacks
January 30, 2024, 05:48:25 pm

In the future it may be for smf 2.1.x? by smithloo
January 30, 2024, 12:55:34 am

Powered by EzPortal