vb.org Archive
Page 22 of 128 « First 122021 22 23243272122 Last »
Show 40 post(s) from this thread on one page

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)

logicuk 12-20-2008 09:45 PM
i just installed 1.2.0 thanks for the new version

what setting do you recommend i use for Cache Forumhome WOL?

Deceptor 12-20-2008 09:47 PM
I personally would use between 30-60 seconds, ofcourse the higher the number the more stale the data becomes, but at a cost of better performance.

bashy 12-20-2008 09:53 PM
Hi

After upgrade i get this DB error now, its to do with the WOL part of your script

Code:
    Database error in vBulletin 3.7.4:
 
  Invalid SQL:
 
              SELECT
                    user.username, (user.options & 512) AS invisible, user.usergroupid,
                    session.userid, session.inforum, session.lastactivity, session.useragent,
                    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
              FROM session AS session
              LEFT JOIN user AS user ON(user.userid = session.userid)
              WHERE session.lastactivity >;
 
  MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
  Error Number  : 1064
  Request Date  : Saturday, December 20th 2008 @ 11:51:47 PM
  Error Date    : Saturday, December 20th 2008 @ 11:51:48 PM
  Script        : http://www.bashys-place.com/forums/index.php
  Referrer      :
  IP Address    : *******
  Username      : ************
  Classname    : vB_Database
  MySQL Version : 5.0.67-

Deceptor 12-20-2008 09:54 PM
Bashy, are you using the homewol? Try disabling that to see if it works - be aware this is untested on vB 3.7, so I'm not sure if it will always work for that version.

veenuisthebest 12-20-2008 09:56 PM
just wow!

Loving the new Optimal settings check, I had all of them optimal already ;)

Profile bug down, can see another WOL query down. Cool

Template problem solved ONLY when XCache Authentification is ON.

Now, I tried to edit a template, the change did not show. Then I checked it again in a minute or two and it shows the edit fine. How did it show when I did/could not flush the cache ?

Thanks a lott.. You're one real php guy I had ever seen, this mod is going to beat the install counts of ibproarcade for sure. :)

logicuk 12-20-2008 09:56 PM
im using 1.2.0 and the WOL with vb 3.7 and its working fine :)

Deceptor 12-20-2008 09:58 PM
veenuisthebest,

The system maybe have found a corrupted template and pulled it again from the database to cache, which is part of the active sector of vB Optimise to ensure data is intact. Either that -or- your XCache has a low TTL (time to live) setting so cache is dropped every 5 minutes or so.

Glad you like the additions, I'll keep aiming to reduce the forum home queries as it's the biggest impact of performance being the most popular page visited on a forum, statistically speaking anyway :)

Bounce 12-20-2008 09:59 PM
ooooooooooooooooo nice update D...

WOL set for 60 secs :)

Had to optimize (or change)..
Store CSS Stylesheets as Files,Save Albums as Files,Save Avatars as Files..

Another 3 queries gone on forumhome:D..

Any faster and my forums will take-off LOL

Deceptor 12-20-2008 10:03 PM
Glad it's working great for you hibees :)

logicuk 12-20-2008 10:08 PM
My forum is so fast now its crazy! this has to be the best mod ever created!!


All times are GMT. The time now is 02:34 PM.
Page 22 of 128 « First 122021 22 23243272122 Last »
Show 40 post(s) from this thread on one page

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.01567 seconds
  • Memory Usage 1,738KB
  • 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
  • (1)bbcode_code_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