If you want to use the eAccelerator content caching API, you have to enable it - simple as that and clearly stated in the eAccelerator documentation :)

What you are asking for is like requesting from Microsoft to support scanning in Paint on you HP OfficeJet without installing the appropriate TWAIN driver - and telling them that it is their fault as the OfficeJet works 100% when printing from Word ...

Guys, can we keep it clean in here? All I'm saying is Deceptor is busting his butt via support so any of the post before mine could have been PM'd after a certain point. It's always the attitudes and arguments on vB.org that make me sad, it's like the special olympics.... even if you win your still retarded ;). (Sorry for playing that card but?)

Now, let's get back to topic and next coder who has valid input, best bet is to PM and resolve w/ Deceptor and I'm sure if it was worthy and useful Deceptor will note your contribution in his post.

Just my 2 cents but I figured it was less than the other useless comments that make non-experienced users have to read through 900 extra post that are arguements....

S-MAN

I must've missed your donation link. Can you post it? (and in the main mod body)

vbulletin should built this mod in vb4.0

this is a masterpiece... :D

It's in the very top post, look for Support Developr on the right hand side tpearl :) I'll PM it too for yah.

Ok i might try that

So which one is best? xcache?

Thanks for your help :)

XCache has shown me and a couple of others the best result, but it can differ depending on your server, ofcourse any cache method other than file cache will be a whole lot better :)

ohh that's what those are ok thanks :)

any plans to support zend?

I guess I never donated before. hah, thanks!

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 :)

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

9 queries instead of 11. All as promissed :)

- 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 :)

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 :)

can i pm you for topic relate to security and my site with this hack ?

Well, I'm sure most showthread queries surpass the template queries in size.. Although I agree it's a most ridiculous way to use the "V" in "MVC" so I hope that changes in 4.0. I'm hoping for something like CodeIgniter where we get a Views folder with all the template files. (And of course the means in default vBulletin to cache these.) :)

I can't think of a better word.... but would it be better for "latency" if we were to only use the Xcache VAR cache for this modification, and tell vBulletin to use nothing but Memcached? (Meaning: So not everything is trying to use the same cache at once)

I was a little foggy on that anyway, because I'm aware that Memcached is capable of a lot more than just caching vB's Datastore, but it seems that if you don't configure vBulletin to use Memcached for the Datastore, then Memcached won't bother caching any other objects into memory, such as query results, etc.

So I guess we can't pick and choose, huh?

I guess I'd be fine with that anyway... This mod = Xcache's var cache, vBulletin = Memcached

tmc - This mod can already use XCache while vBulletin uses Memcache, unless I'm missing your point?

dvt100 - The security flaw would be, any other administrator would be able to see your XCache password, and while the only threat would be if you had the XCache page which required user/pass, they could login. Nothing more or less, as far as I know.

ok thanks i glad this wont affect me at all .would be nice if next update can have my request as optional thanks.

Yeah, a little bit. haha. :)

It's fine, though. I can't really state it any better. I'll just have to mosy on over to vB dot com and ask them if I can use Xcache for the Datastore, but still have Memcached do all the non-Datastore object caching. Meaning: Memcached can do LOTS more than store the measly 1MB of Datastore data, but I think vBulletin forces me into using Memcached for BOTH or not at all.

I just figured since you poked your head around inside all the vB internals you may already know the answer. :)

The only thing vBulletin caches on its own using any cacher is the datastore, unless you're referring to other things vBulletin caches aside from the datastore? Sorry I'm not getting your point :)

Like I said, data is similar from last week. Keep in mind that this is the amount of data being passed between two servers and not from server to user. The decrease in data transferred to users is minimal.

After installing and using Filecache as only method I can use, FORUMHOME is around 30% slower than without installing this mod even if there are 3 queries less. Could there be something I did wrong?

ThrostenA - Filecache is not the best, and if your servers harddrives aren't that fast you'll notice slower page generation times. Try use a difference cache method, XCache seems to have the best results. If you're unsure how to install the extensions, ask your host for assistance :)

Hi Deceptor,

I'm using version 1.3.2 of the mod on a 3.7.4 board with vBSEO installed. It installed easily and evidently correctly. I can see that it is cutting down on the db queries as billed and caching some of the data. I am using XCache and enabled that feature. I can see from the XCache admin panel that the mod is accessing the variable cache. I am getting warnings for many of the template entries (eg vbactivecache_template_xxxxxx) as follows:

The cache in such cases appears to be empty.

Any ideas on why this is happening and if there is an effect?

What templates are blank exactly Jim_O? (You put 'xxxxx' in your post).

In either case, the php error is caused by the xcache script because it didn't anticpate for blank variables, you could probably edit the script and change htmlspecialchars to @htmlspecialchars on line 4.

1.2.0 working like a dream on 3.7.4 with xcache

There are probably 200-300 of them. Here are a sampling:

• vbactivecache_template_12598
• vbactivecache_template_12882
• vbactivecache_template_3675
• vbactivecache_template_12523
• vbactivecache_template_12527
• vbactivecache_template_12815
• vbactivecache_template_12819
• vbactivecache_template_12747
• vbactivecache_template_12679
• vbactivecache_template_12895
• vbactivecache_template_13045
• vbactivecache_template_12820
• vbactivecache_template_12824
• vbactivecache_template_8110

Pretty much anything that starts with "vbactivecache_template_" is empty.

When there is what appears to be an intentionally blank cache, such as "vbactivecache_phrase_calformat2override_1" it shows the following data:

"{_______VB_ACTIVE_CACHE_BLANK_______}"

These others are simply blank.

Many have multiple hits and "sizes" as large as 15K.

FWIW, if you are interested in system info, I am using XCache 1.2.2 which I compiled from source and run php 5.2.8 as a fastcgi using php-fpm as a controller, also compiled from source. The web server is nginx 0.7.27. No other scripts are accessing XCache and the system seems to be running fine although volume is very light at this moment with people out Christmas shopping or whatever else that they might be doing this time of year.


That eliminates the warning but not the hundreds of blank caches.

Jim_O - Where you see the numbers, run this query:
[sql]select * from template where templateid = xxx[/sql]

You'll probably need to put your table prefix before "template". My guess is you've uninstalled templates, but mods are still trying to run them. But if I'm wrong let me know the result of your query, and if the template in your database actually has any information.

Nope. Those queries return lots of data.

For instance:


select * from vb_template where templateid = 8110:


select * from vb_template where templateid = 13045


So these are some fairly standard templates it would seem.

I do have styles that are unavailable for users to select, but enabling them, flushing the cache and looking again made no difference on the empties. Like I said, all template caches appear to be empty. :confused:

For some reason the template content isn't being cached. If you turn on vB debug mode, does vB optimise tell you it's fetched templates from cache, or that it needs to query them to cache?

If unsure where vB Optimise messages are, it's the bottom drop down menu on your pages after enabling debug mode, which can be done like so by adding this in config.php:

It says that it got 86 templates from the cache and 0 fetched from the database so it seems to be working.

Maybe it's best I ignore what XCache is telling me (?), though it seems odd, and it only appears with this product.

Another suggestion Deceptor

vblog could probably do with one of your great optimizations ^^

When vB Optimise is active, when clicking the save button after editing a post, the revised data is saved into the database, but the screen is left at the editor mode instead of refreshing into a normal post display.

shlomot I tried quick and advance edit in 3.7.4 and the edit box went away and the post was updated correcty