albertlast

To solve this issue in his fully complexity i would say, you need to handle the error not any more as a string, sutch as you had to handle the...

@jdarwood007 since you use explain instead of analyze you output doesn't show anything userfull.

since sql get different execute by a database based on settings and size of the table, it make no sense to take a small setup to try a optimization for...

sql command ```sql SELECT ln.id_member, ln.id_board, ln.id_topic, ln.sent, mem.email_address, mem.lngfile, mem.pm_ignore_list, mem.id_group, mem.id_post_group, mem.additional_groups, mem.time_format, mem.time_offset, mem.timezone, b.member_groups, t.id_member_started, t.id_member_updated FROM smf_log_notify AS ln INNER JOIN smf_members AS mem ON...

the amount of rows doesn't look good to me for an performance test, could you go higher? somthing in a more smf.org size

the base is real, yea, but i see "showing rows 0", which mean that no return happening. a real world example is better than i trying to simulate this in...

created a test case where return amount is ~4k rows, pg 14 in ms: | Query # | 4k rows | emtpy | 4k rows index | empty index |...

Could you add and explain analyze of the orginal and changed query?

> > Could you add and explain analyze of the orginal and changed query? > > Just read the linked topic, all the info is there. https://www.simplemachines.org/community/index.php?topic=588288.msg4170667#msg4170667 no this information...

in my eyes the fallback scenario is not a valid option, since the content could be dangerous. So a bad guys could try to force here fallback scenario, add dangerous...