Announcement

#1 2011-06-13 23:47:32

jortex696
Member
2010-05-13
62

mysql performance problem

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?


http://i54.tinypic.com/2dviweo.jpg

Offline

 

#2 2011-06-14 00:23:41

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13786

Re: mysql performance problem

Hi jortex696,

I can't clearly see the SQL query. Can you copy it on the forum please?

Offline

 

#3 2011-06-14 01:31:57

jortex696
Member
2010-05-13
62

Re: mysql performance problem

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/

Last edited by jortex696 (2011-06-14 01:50:08)

Offline

 

#4 2011-06-16 18:03:52

jortex696
Member
2010-05-13
62

Re: mysql performance problem

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

 

#5 2011-06-20 12:53:27

flop25
Piwigo Team
2006-07-06
7037

Re: mysql performance problem

I notify again plg, aka the master of sql ^^


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact