Craft-Plugin--Redirect-Manager icon indicating copy to clipboard operation
Craft-Plugin--Redirect-Manager copied to clipboard

Published 20 hours ago • verified publisher icon rkingon

Performance Improvement

Open rubenwebs opened this issue 8 years ago • 1 comments

Hi,

Someday when you got time, you could also improve on performance. We had a website with 10.000 redirects in the manager and the memory exploded, because the redirect manager loads all the rows of the table into Craft.

My suggestion is to query on the database first for finding the right redirect, instead of loading everything in.

rubenwebs avatar Apr 05 '16 08:04 rubenwebs

Yea, 10k is a ton!

The problem is the way it matches, via regex. mysql has some basic regex support but I haven't really looked into it.

I think the operator would be RLIKE -- I'll play with it

rkingon avatar May 03 '16 05:05 rkingon