Closed ar-jan closed 1 year ago
Performance looks fine, but declaring collate nocase
in the index may be faster than using it (only) directly in the query.
Edit: used collate nocase
for the relevant colums, hence indexes as well.
Added default_cache_ttl
, num_sql_threads
settings.
--inspect-file
for performancedefault_cache_ttl
num_sql_threads