Bug #22853 See Comments

SELECT query is affecting the database performance

Version: 2.11.4 Reporter: bandari

This is an archived bug report. If you are experiencing a similar issue, upgrade to the latest release and if that does not solve the problem, submit a new bug report

HI:

We are having an issue with an specific query. We need to know what channel entry instruction is triggering these kind of queries (example added below) because is taking too long to load and makes the site non-responsive. Hope you can help.

SELECT * FROM (exp_files) WHERE upload_location_id IN (‘1’) AND file_name IN (‘binary Muertos26.jpg’, ‘binary invitaareflexionar-1482731731.jpg’, ‘binary transcurrenencalma-1482734505.jpg’, ‘binary descartandesabasto.jpg’, ‘binary rickymartin.jpg’, ‘binary CAÑADA-DE-LA-ROSA.jpg’)

Saludos Cordiales,

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases