I have approximately 1,600,000 images in 50,000 categories.
and I have a performance problem, there is a specific query processor is consumed.
What can be done about it?
Offline
Hi jortex696,
I can't clearly see the SQL query. Can you copy it on the forum please?
Offline
plg wrote:
Hi jortex696,
I can't clearly see the SQL query. Can you copy it on the forum please?
This is the query...
only 1 query...
---------------------------------------------------------------------
SELECT DISTINCT (
id
)
FROM piwigo_images
INNER JOIN piwigo_image_category ON id = image_id
WHERE cat
---------------------------------------------------------------------
my database image...
http://imageshack.us/photo/my-images/12 … image.jpg/
Last edited by jortex696 (2011-06-14 01:50:08)
Offline
jortex696 wrote:
plg wrote:
Hi jortex696,
I can't clearly see the SQL query. Can you copy it on the forum please?This is the query...
only 1 query...
http://i56.tinypic.com/23mwtty.jpg
---------------------------------------------------------------------
SELECT DISTINCT (
id
)
FROM piwigo_images
INNER JOIN piwigo_image_category ON id = image_id
WHERE cat
---------------------------------------------------------------------
my database image...
http://imageshack.us/photo/my-images/12 … image.jpg/
anyone have any idea how this could be improved
problem?
Offline
I notify again plg, aka the master of sql ^^
Offline