vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Board Optimization - [DBTech] vB Optimise 2.0.1 (Lite) (https://vborg.vbsupport.ru/showthread.php?t=199207)

Deriel 12-20-2008 09:57 AM

Really nice Mod, nominated it already :)

I'm using vB 3.8rc2 and everything seems to be ok. Just one curiosity: using XCache with this mod seems faster than useing memcache (yeap, I have both installed)

logicuk 12-20-2008 10:10 AM

Running php5, memcache 3, vb 3.7

Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.30642 seconds
* Memory Usage 16,407KB
* Queries Executed 54 (?)

So after i install this it it uses an extra 21 queries??? and also makes my pages load slower??

GreasySpoon 12-20-2008 10:13 AM

Quote:

Originally Posted by Deceptor (Post 1689277)
If anyone has any suggestions, be sure to let me know and I'll try get them in the next update :)

Maybe precaching the templates? So that the Add-On dont have to check if the Templates, Styles, ... are already cached or not?

Really nice work. Thumbs up :up:

veenuisthebest 12-20-2008 10:23 AM

Quote:

Originally Posted by logicuk (Post 1689459)
Running php5, memcache 3, vb 3.7

Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.30642 seconds
* Memory Usage 16,407KB
* Queries Executed 54 (?)


So after i install this it it uses an extra 21 queries??? and also makes my pages load slower??


Is this the debug info for forum/index.php ?

First of all 33 queries by default is damn too much. Its just 15-16 quries on my index.php or any other forum.

And there's no way it can increase the number of queries.

Make sure you have have enabled all the settings of the mod (they are off by default) and selected Memcache in the mod.

If problem persists, you seriously need to optimize your site. Try disabling unnecessary addons/mods and see the effect.

logicuk 12-20-2008 10:49 AM

Quote:

Originally Posted by veenuisthebest (Post 1689464)
Is this the debug info for forum/index.php ?

First of all 33 queries by default is damn too much. Its just 15-16 quries on my index.php or any other forum.

And there's no way it can increase the number of queries.

Make sure you have have enabled all the settings of the mod (they are off by default) and selected Memcache in the mod.

If problem persists, you seriously need to optimize your site. Try disabling unnecessary addons/mods and see the effect.

Yes this is the debug info for forum/index.php

I have enabled the mod and selected memcahce

And i cant disable any mods, my site is very custom

tmc 12-20-2008 11:25 AM

Quote:

Originally Posted by logicuk (Post 1689459)
Running php5, memcache 3, vb 3.7

Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.30642 seconds
* Memory Usage 16,407KB
* Queries Executed 54 (?)


So after i install this it it uses an extra 21 queries??? and also makes my pages load slower??

This is just plain wrong.. You don't even explain if it's on the EXACT same page. Seems to me like your website is adding extra queries per post or per thread, (I don't know what script you're taking this info from) and you happen to be comparing different pages.

It's not possible that this mod added 21 queries.

That being said, you really need to hire somebody to fix those query issues and the amount of memory being taken up. I don't quite get how the page you're loading is taking 16MB of memory...

Here's a SHOWTHREAD example:
Quote:

Page generated in 0.02043104 seconds (73.73% PHP - 26.27% MySQL) with 6 queries 2,085.35KB Used
and FORUMHOME:
Quote:

Page generated in 0.01459694 seconds (66.00% PHP - 34.00% MySQL) with 5 queries 1,470.00KB Used

tmc 12-20-2008 11:50 AM

Quote:

Originally Posted by logicuk (Post 1689485)
Well i did explain that the results are from the same page if you took time to read my post in full

and like i said my site is very very custom go take a look at http://www.thcfarmer.com/forums/

and you will see what i mean.

I wasn't even quoting your last post, and I didn't even read/see it. I "took the time" to see that both your before AND after results are ridiculous and therefore this mod is most likely not the problem. I would attribute it to a website running poorly coded mods.

I see 8-10 queries on your FORUMHOME, not 33-54. So chances are you should optimize your mods first and try again.

logicuk 12-20-2008 12:51 PM

Quote:

Originally Posted by tmc (Post 1689486)
I wasn't even quoting your last post, and I didn't even read/see it. I "took the time" to see that both your before AND after results are ridiculous and therefore this mod is most likely not the problem. I would attribute it to a website running poorly coded mods.

I see 8-10 queries on your FORUMHOME, not 33-54. So chances are you should optimize your mods first and try again.

And how are you seeing 8-10 queries??

* Page Generation 0.26787 seconds
* Memory Usage 16,049KB
* Queries Executed 51 (?)

Lizard King 12-20-2008 12:54 PM

Quote:

Originally Posted by logicuk (Post 1689485)
Well i did explain that the results are from the same page if you took time to read my post in full

and like i said my site is very very custom go take a look at http://www.thcfarmer.com/forums/

and you will see what i mean.

Yes you have a customized style but there is nothing extra on your forum index to run 33 queries

Edit : Sorry i just realized you are also using vbadvanced cmps. That explains everything

tmc 12-20-2008 01:23 PM

Quote:

Originally Posted by logicuk (Post 1689498)
And how are you seeing 8-10 queries??

* Page Generation 0.26787 seconds
* Memory Usage 16,049KB
* Queries Executed 51 (?)

As in: That's all it should be taking to pull this information onto FORUMHOME. Given it is properly coded.

It wasn't an actual observation, but my estimate of what your query count should really be. You should hire someone to optimize your queries, as they are probably destroying your server.


All times are GMT. The time now is 07:37 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02202 seconds
  • Memory Usage 1,755KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete