[Plugin: Cross-linker] Problems after 1.4.0 Update

Hm… On my server and websites everything works fine. It must be somehow related to global variables as the process of loading data has been modified.

In 1.4.0 data are loaded only once at the beginning. Previous versions of cross-linker data were loaded each time the function was called. The real difference is this:

In 1.4.0 data are loaded into global variables, and thus when they’re loaded, there is no need to execute functions which load data from MySQL more than once. The result is: 1.4.0 is faster than previous versions.

In versions lower than 1.4.0 cross-linker loaded data from MySQL each time the function was called. So… each post, each comment… If some post contained 50 comments, data were loaded 51 times during showing 1 single page (50 comments + 1 post). Imagine that you had 500 word:URL connections. That means 51×500 selected rows during loading 1 single page. This causes slow loading time.

I’m going to modify the thing and make an option between using 1.4.0’s data loading algorithm or 1.3.2’s data loading algorithm… Until I find and fix the reason of this unexpected (and to me also weird) problem.

so if I have a post with 2 comments … I currently (1.3.2) have 330 queries … with 1.4.0 … I have over 750 querie …

I have about 32 words linked to URLs

Would it make sense if I install a cache module? could you recommende one?

In fact, in 1.4.0 there should be less MySQL queries, so it makes no sense to me :-S . Caching would be great, although I don’t know any caching plugin for WP yet.

Anyway, wait and use 1.3.2 for now. I started working on ability to select the data loading algorithm + it will also offer loading data from text files. It will be OK.

As soon as I finish and test the new version it will be released here.

Update:

Please, update your crosslink.php and use this:

https://www.aqua-fish.net/temp/crosslinker/shsc.php

And let me know if it works, please.

Thanks!

Thank you – I will try it later on and let you know.

It seems that this fixed the problem – is it version 1.4.1 or is it an other release? should I use 1.4.1 instead of the php you posted here?

1.4.1 is what I mentioned above, so you don’t need to upgrade. It’s the same except the version number in the crosslink.php and readme.txt.

Thanks for telling me about the problem ?? .

No problem … is it now using the “new engine” or the old or was it an other bug/problem?

In fact it was my mistake. I forgot to declare $nn as a global variable and this caused the entire problem. Core is still the same. On many computers $nn was automatically 0, so it didn’t cause any overloading or crashing. But some servers assigned high or even infinite values to $nn… this led to overloading and crashes of some machines.

Later I may upgrade it in order to be loading process purely text files-based (this will increase the speed), but for now everything is OK. Especially big blogs don’t suffer from often and unnecessary load of data from MySQL.