https://hackmysql.com/post/deferred-join-deep-dive/https://aaronfrancis.com/2022/efficient-pagination-using-deferred-joins
Simple Query
select * from t order by x limit 500, 20
Optimized Query
select * from t join (
select pk from t order by x limit 500, 20
) dt using(pk)
I have tested it on...
I think this is bad practice to support several major versions in JS file. Will be better to separate code on few JS files via XF template like this:
<xf:if is="{$xfOptions.versionId} >= 2300070">
<xf:js src="myaddon/vendor/scripts/2.3/core.js" />
<xen:else />
<xf:js...
Are there any server-side settings of Redis for a high-load project?
We tried to use Redis on our high load project (10 000 queries per second) and had problems with page loading (too long response from Redis like 1s instead 0.0006s for Libmemcached). We tried to enable Redis only for few people...
Hello. I have a big project using XenForo 1.5.24 with hand made plugins and custom theme, so i can't upgrade it to XF 2.
I need a plugin or code changes to integrate froala editor instead default editor of XenForo 1.x
Award 500$ in cryptocurrency. I can make prepayment if you have a reputation...
Yes, im already using your addon, but it doesn't affect my problem. Can you update this plugin? You will receive good reward from me
My telegram: @lolzteam_old