version 1.4 works better than version 2.0

AWS server, Bitnami ubuntu stack w NGINX, MySQL 8

2.0 is very, very, very slow compared to 1.4. In fact its not really usable at all.

I have over 20 000 posts.

just tested it again….the progress bar also giving me results of 456 % – very slowly

going back to old version

ok, all tests were

first time:

version 2.0
regex: yes
case insensitive: yes
search: https:\/\/jooble\.org\/desc\/(.*?)\?.*
replace: https://jooble.org/desc/\1?p=1
target: post meta value

version 1.4

the same except search is surrounded by “@”, so
@https:\/\/jooble\.org\/desc\/(.*?)\?.*@

*to note – the speed difference is MAJOR.

on version 1.4, it is lightening fast
on version 2.0.. like a snail

I then tested again, the same results…then a 3rd time without regex and with on the post title – and same difference in speed

third time:

version 2.0

regex: no
case insensitive: yes
search: `& amp ;’
replace: &
target: post title

(in the ‘search’ I have put a spaces just here – there is a bug in this wordpress.org comment area where the html ampersand, even if enclosed with the ‘code’ option, does not come out)

version 1.4

same as above but with search surrounded with “@”

I noticed in version 2.0 you mention PHP regex. Does this mean version 2.0 uses PHP to process and version 1.4 uses regex native to mySQL?

that could explain massive speed difference.

in all tests – I backed up database with mysqldump beforehand, and imported again before next test. using mySQL 8

I could also make a video showing the drastic difference in speed if you like, just didnt get around to it yet

• This reply was modified 6 years ago by ben303.
• This reply was modified 6 years ago by ben303.
• This reply was modified 6 years ago by ben303.