vb.org Archive - Board Optimization - [DBTech] vB Optimise 2.0.1 (Lite)

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)

Quote:

any plans to support zend?

Could you elaborate please? :)

Quote:

Originally Posted by Deceptor (Post 1691259)

Could you elaborate please? :)

I think i got it wrong...

i thought zend optimiser was a php cache (that's what my webhosting told me) that's why i was asking.

Sorry

*sight*

Ah, Zend Optimiser you mean? It's to encode scripts mostly, but by encoding it makes them run a little faster, not what vB Optimise does exactly :)

Quote:

Originally Posted by Deceptor (Post 1691177)

lolo - It doesn't cache all mods I'm afraid, the only mod this currently extends to is vBAdvanced.

no problem it's just a question ;) very nice work :)

Quote:

Originally Posted by veenuisthebest (Post 1691035)

Don't you find a reduction in the number of queries?

9 queries instead of 11. All as promissed :)

Quote:

Originally Posted by Deceptor (Post 1691058)

Vitaly - I make no claim to instantly reduce server load, but it may impact it if vB Optimise has done a lot of optimisation ontop of what you had before, so a reduction of two queries wouldn't be significant enough - that said it depends on the amount of users you have active and your server. What cache method are you using?

- eaccelerator for php code, memcached in all vb settings.
- 500-600 online.
- ~0.9 sec for main page, ~0.3 for others.
- nginx + 6 php-fcgi + 1 mysql processes.

(*) WOL was off.

Anyway, your mod is a good example of clear coding and outstanding support. Such functionality MUST be included in vB by default.

If you know some trustable non sintetic methods to measure load & latency - i could try.

Vitaly - Your server seems setup so well that a change in page generation time would require some huge changes, the two queries reduced will probably just effect queries ofcourse, and internal bandwidth (especially if you use another server for your database).

As for measuring load and such, I'm afraid not. Still, it has had some positive impact on your forum :)

any chance to have a box to write xcache login info to make this work even better?

this hack work really good .
thanks

dtv100 - I have considered this, but it may be unsecure. That said, I can place it in the next version purely as being optional :)

Quote:

Originally Posted by tpearl5 (Post 1691195)

I installed this mod in the middle of the day on the 20th. Here is some hard proof that it is working wonderfully; stats from my database server's bandwidth. (outbound is mostly database data going to the web server to render a page)

https://vborg.vbsupport.ru/external/2009/02/103.jpg

pay no attention to the data compiled for today the 22nd as it is not complete

I should include that last sunday's traffic (14th) was very similar to this sunday's (21st). I am using memcache. There is also a similar trend on the web server's inbound data.

Outbound bandwidth has decreased by ~47% on the database server!!! (based one day of similar data) What does this mean for most of you? Fewer database queries = lower server load = faster site = happy forum users!

Bottom line: This mod is going to save me money as I am currently going over on my bandwidth as well as improve user experience!

Nominated for mod of the month and will be donating

While I'd say this is certainly fantastic.... could it be the holidays, mostly? You should see a relative decrease in all traffic, CPU and RAM utilization, and so forth if that were the case.

I just can't imagine disabling 2-3 global queries has such a large impact... Esp w/ one of them being such a small query.. (The style one)

Of course if it continually stays that low, good work Deceptor!! :)

tmc - While I agree it could be holidays, the templates query is the largest query vB executes, so I would expect some impact. In anycase, it'd be nice to see the results over a longer period :)

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02512 seconds Memory Usage 1,746KB 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 (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)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
Messages: