Pb filtering with regular expression on select result with blob.

starf's profile image starf posted 1 month ago in General Permalink

Hello, I'm facing a performance problem, with 12.13, when trying to apply a regular expression filter of the kind "xx.xx" on the result table of a select. When the table contains a blob column (a png image in my case, of about 70ko), with about 1k rows, then when I type the "" in the filter, the application freezes, with one cpu at 100%, then after many minutes, I killed the app. I also tried on a very reduced result set, of just 4 columns, one blob and 10 rows, then inserting the "*" results in a delay of 4 seconds to get the filtered rows. It looks like the implementation of regular expression filtering on blobs is very very slow.

Best regards.

Please login to leave a reply, or register at first.