Piwigo.org

You are not logged in. (Register / Login)

Announcement

#1 2011-07-15 00:56:00

jortex696
Member
Registered: 2010-05-13
Posts: 62

Slow Querys

SLOW QUERYS...

Consultations are piwigo to take up to 500 or more seconds ...
I'll take some pictures, to visualize my problem.

Is there anyone who can help me?

i have core i7 second Generation.


http://s2.subirimagenes.com/privadas/previo/thump_1548104snap1.jpg

http://s3.subirimagenes.com:81/privadas/previo/thump_1548107snap3.jpg

http://s3.subirimagenes.com:81/privadas/previo/thump_1548115snap6.jpg

---------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------

SELECT DISTINCT (
image_id
)
FROM piwigo_image_category
INNER JOIN piwigo_images ON id = image_id
WHERE 1 =1
AND (
category_id NOT
IN ( 972, 2749, 2750, 2923, 2924, 4368, 3795, 3796, 3797, 3800, 3801, 4235, 4222, 4278, 45589, 45769, 45469, 45471, 45470, 45462, 45463, 45465, 45466, 45467, 45468, 45456, 45457, 45458, 45459, 45460, 45461, 45421, 46480, 46481, 47946, 48004, 47954, 47960, 47948, 47947, 49906, 49907, 46284, 46285, 51303, 51312, 43953, 43954, 44319, 44322, 44320, 44321, 44177, 44178, 44180, 44182, 44181, 44184, 44179, 44183, 44196, 44197, 44173, 44176, 44174, 44175, 44162, 44165, 44163, 44164, 44244, 44245, 44285, 44287, 44289, 44288, 44291, 44286, 44290, 45116, 45117, 45106, 45107, 44918, 44919, 44954, 44956, 44957, 44889, 44890, 45039, 45040, 44609, 44597, 44598, 39812, 38866, 39086, 38945, 53033, 52646, 52652, 52683, 52656, 52688, 52654, 52685, 52682, 52687, 52686, 52657, 52653, 52655, 52684, 52689, 52668, 52677, 52659, 52675, 52662, 52669, 52666, 52667, 52681, 52660, 52672, 52665, 52679, 52663, 52674, 52671, 52678, 52676, 52670, 52664, 52673, 52680, 52730, 52735, 52733, 52731, 52732, 52734, 52736, 52716, 52717, 52718, 52719, 52720, 52567, 52585, 52571, 52578, 52588, 52568, 52586, 52572, 52579, 52576, 52577, 52592, 52569, 52582, 52575, 52590, 52573, 52584, 52581, 52589, 52587, 52580, 52570, 52574, 52583, 52591, 52700, 52701, 52702, 52703, 52704, 52741, 52742, 52743, 52744, 52745, 52565, 52566, 52705, 52706, 52707, 52708, 52696, 52697, 52698, 52699, 52746, 52747, 52748, 52597, 52598, 52599, 52593, 52594, 52595, 52596, 52709, 52710, 52711, 52712, 52713, 52603, 52604, 52605, 41310, 41311, 41307, 41309, 41308, 33337, 33762, 33683, 33758, 33673, 33666, 33761, 33753, 32159, 32147, 32128, 32130, 32161, 32127, 32152, 32144, 32135, 32160, 32146, 32133, 32162, 32295, 30783, 31410, 32076, 32852, 32778, 31810, 31809, 31779, 31813, 31795, 30403, 29653, 29985, 29931, 30085, 29711, 29898, 29873, 30483, 30283, 29823, 30215, 30189, 29725, 30131, 30576, 30611, 30608, 30357, 29978, 29980, 29982, 29979, 29981, 29614, 29617, 29615, 29616, 30019, 29604, 29607, 29605, 29606, 29626, 30381, 30384, 30382, 30383, 16360, 16025, 16063, 16036, 16039, 16038, 16040, 16037, 13640, 13641, 13642, 13666, 13667, 17625, 17626, 17430, 17431, 17432, 16594, 16595, 16928, 16929, 16716, 16717, 16633, 16634, 15243, 15244, 15245, 15246, 15241, 15242, 15239, 15240, 9955, 9935, 9958, 9739, 10012, 20806, 20838, 13024, 13025, 12982, 12983, 12994, 12995, 12904, 11231, 11238, 10420, 8975, 8974, 9212, 8791, 9260, 9135, 27150, 27151, 27152, 27032, 27033, 27034, 27261, 27262, 27263, 27153, 27154, 27155, 27024, 27025, 27208, 27209, 27210, 27226, 27227, 27105, 27106, 27426, 27427, 27447, 27448, 27424, 27425, 27456, 27457, 27458, 27432, 27433, 27428, 27429, 27451, 26724, 26725, 26656, 26657, 26693, 26694, 26695, 26740, 26741, 26696, 26697, 26712, 26713, 26698, 26699, 26722, 26723, 26700, 26701, 26658, 26659, 26667, 26668, 26689, 26690, 26704, 26705, 26669, 26670, 27890, 27891, 27820, 27821, 27792, 27793, 27803, 27864, 27865, 27747, 27748, 27749, 27822, 27823, 27843, 27844, 27787, 27788, 27398, 27399, 27367, 27368, 27375, 27376, 27377, 27402, 27403, 27353, 27356, 27354, 27355, 27369, 27370, 27327, 27328, 27304, 27305, 27340, 27341, 27342, 27306, 27307, 27298, 27299, 27323, 27324, 26879, 26880, 26995, 26996, 26881, 26882, 26883, 26884, 26753, 26754, 26901, 26902, 26766, 26767, 26838, 26839, 26967, 26968, 26969, 26806, 26809, 26807, 26808, 27499, 27500, 27497, 27498, 27492, 27493, 27494, 27477, 27478, 27479, 27471, 27474, 27472, 27473, 27501, 27504, 27502, 27503, 27488, 27489, 27495, 27496, 27480, 27481, 27527, 27530, 27528, 27529, 27619, 27620, 27621, 27713, 27714, 27717, 27718, 27601, 27602, 27522, 27523, 27524, 27671, 27672, 27652, 27653, 27551, 27554, 27552, 27553, 27531, 27532, 27699, 27702, 27700, 27701, 27573, 27574, 27540, 27541, 27564, 27565, 27642, 27643, 27644, 27677, 27678, 27632, 27633, 27695, 27698, 27696, 27697, 27629, 27630, 27631, 27673, 27676, 27674, 27675, 27557, 27558, 27559, 27615, 27616, 27638, 27639, 27570, 27585, 27586, 27560, 27561, 27581, 27584, 27582, 27583, 27606, 27607, 27608, 24330, 24331, 24705, 24706, 24605, 24607, 24611, 24606, 24610, 25012, 25014, 25016, 25015, 25018, 25013, 25017, 24713, 24716, 24714, 24715, 24846, 24847, 24717, 24718, 24989, 24990, 24485, 24491, 24492, 24538, 24539, 24926, 24925, 24928, 24923, 24900, 24903, 24906, 24901, 24905, 24779, 24564, 24565, 24566, 24447, 24450, 24448, 24449, 25630, 25631, 25749, 25750, 25639, 25640, 25747, 25748, 25632, 25634, 25636, 25633, 25635, 25663, 25664, 25725, 25721, 25722, 25734, 25735, 25653, 25654, 26557, 26558, 26563, 26564, 26586, 26587, 26608, 26609, 26515, 26516, 24150, 24148, 23789, 23790, 23791, 24009, 24012, 24010, 24011, 23965, 23968, 23966, 23967, 24224, 24225, 24017, 24018, 24134, 24135, 23884, 23885, 23916, 23917, 24152, 23913, 23912, 23911, 23914, 24133, 24045, 24046, 24065, 24066, 24067, 24114, 24117, 24115, 24116, 24145, 24146, 24105, 24108, 24106, 24107, 24192, 24193, 23792, 23793, 24019, 24020, 24140, 24141, 23928, 23929, 23930, 24063, 24064, 24061, 24062, 23860, 23861, 23935, 23936, 23937, 23870, 23854, 23855, 25425, 25426, 25537, 25538, 25485, 25486, 25569, 25570, 25608, 25609, 25610, 25553, 25554, 25462, 25463, 25606, 25607, 25468, 25469, 25460, 25461, 25066, 25067, 25297, 25298, 25151, 25152, 25314, 25315, 25334, 25335, 25279, 25280, 25169, 25170, 25316, 25317, 26412, 25819, 25821, 25823, 25820, 25822, 25844, 25845, 26185, 26186, 26187, 26465, 26466, 26189, 26190, 26193, 26197, 26471, 26472, 26473, 26103, 26104, 25829, 25830, 26384, 26385, 26386, 26317, 26318, 26199, 26200, 25926, 25927, 25928, 25935, 25938, 25936, 25937, 25861, 25864, 25862, 25863, 26449, 26452, 26450, 26451, 26013, 26014, 25899, 25826, 25827, 25828, 25985, 25986, 25987, 25988, 25989, 26157, 26154, 26156, 26277, 26280, 26278, 26279, 25990, 25991, 26056, 26059, 26057, 26058, 26032, 26416, 25971, 25975, 25974, 25977, 25972, 25976, 26021, 26024, 26023, 26026, 26022, 26025, 26375, 26374, 26377, 26372, 26376, 26230, 26232, 26234, 26231, 26233, 25807, 25809, 25811, 25808, 25810, 26268, 26272, 26269, 26271, 26274, 26273, 26276, 26270, 26275, 26340, 26343, 26341, 26342, 26405, 26408, 26407, 26410, 26406, 26409, 26208, 26211, 26209, 26210, 26325, 26326, 26327, 26443, 26446, 26444, 26445, 25851, 25852, 25853, 26201, 26202, 26401, 26402, 26041, 26042, 26161, 26264, 26265, 26262, 26263, 26004, 26050, 26053, 26051, 26052, 26438, 26436, 26355, 26356, 25948, 25950, 25952, 25949, 25951, 23669, 23670, 23341, 23342, 23566, 23567, 23525, 23528, 23527, 23530, 23524, 23529, 23571, 23576, 23577, 23580, 23575, 23573, 23579, 23472, 23473, 23372, 23373, 23374, 23540, 23541, 23542, 23452, 23453, 23620, 23621, 23462, 23463, 23464, 23492, 23493, 23445, 23447, 23449, 23446, 23448, 23700, 23701, 23343, 23344, 23486, 23487, 23695, 23697, 23694, 23437, 23370, 23371, 23426, 23429, 23428, 23431, 23427, 23430, 23537, 23538, 23539, 27936, 28056, 28177, 22160, 22058, 22059, 22290, 22153, 22712, 22716, 22717, 22718, 22713, 22714, 22715, 22702, 22703, 22707, 22704, 22706, 22709, 22708, 22711, 22705, 22710, 22525, 28263, 28474, 28499, 28389, 28397, 28398, 28432, 28433, 22802, 22803, 22835, 22836, 22846, 22847, 22800, 22801, 22839, 22841, 22838, 22813, 22815, 22814, 22817, 22805, 22809, 22845, 22843, 22851, 22849, 22830, 22828, 22834, 22832, 23227, 22950, 22951, 22924, 22925, 22926, 22927, 23047, 23048, 23039, 23040, 23056, 23057, 23049, 23050, 23091, 23092, 23111, 23112, 23078, 23079, 23100, 23101, 23085, 23086, 22859, 22860, 22852, 22853, 22856, 22857, 22858, 22966, 22967, 22968, 22969, 22956, 22957, 22960, 22961, 22981, 22982, 22972, 22973, 22974, 22983, 22984, 23172, 23173, 23205, 23206, 23191, 23192, 23213, 23214, 23161, 23162, 23159, 23160, 23138, 23139, 8464, 23016, 8319, 22994, 8449, 23014, 23015, 8432, 8335, 8376, 8377, 8424, 8651, 8652, 8678, 8679, 8658, 8659, 8649, 8650, 8653, 8654, 8687, 8688, 8645, 8646, 8641, 8642, 8661, 8695, 8696, 8697, 8666, 8667, 8668, 8708, 8709, 8710, 8692, 8693, 8694, 8669, 8670, 8671, 8663, 8664, 8665, 8701, 8703, 8705, 8702, 8704, 8682, 8683, 8706, 8707, 8632, 8633, 8643, 8644, 8711, 8712, 8674, 8675, 8657, 8689, 8690, 8691, 8684, 8685, 8686, 8029, 8030, 8039, 8040, 7974, 7975, 7986, 7987, 7972, 7973, 7923, 8252, 8253, 8259, 8260, 8261, 8262, 8250, 8251, 7914, 7917, 7918, 7921, 7922, 7919, 7920, 7915, 7916, 8049, 8050, 8065, 8066, 8051, 8052, 8042, 8043, 8057, 8058, 8071, 8072, 7763, 7764, 7816, 7817, 7694, 7695, 7641, 7642, 7668, 8499, 8500, 8731, 8729, 8741, 8740, 8730, 8738, 8739, 8733, 8736, 6841, 6869, 7360, 7282, 7283, 7284, 7157, 7160, 7149, 7150, 7151, 7152, 7138, 7154, 7147, 7141, 7066, 7067, 7095, 6777, 6778, 6705, 6706, 6748, 6749, 6774, 6775, 6776, 6684, 6685, 6804, 6805, 6806, 6733, 6734, 6790, 6791, 6735, 6736, 6509, 6636, 6472, 6614, 6615, 6455, 6603, 6604, 6469, 6612, 6505, 6633, 6634, 6635, 6526, 6641, 6476, 6617, 6616, 6618, 6512, 6637, 6423, 6588, 6589, 6479, 6619, 6546, 6547, 6406, 6542, 6402, 6540, 6384, 6385, 6357, 6358, 6390, 6392, 6391, 6380, 6381, 6382, 6383, 6386, 6388, 6387, 6389, 6359, 6360, 6363, 6364, 6324, 6325, 6242, 6243, 6258, 6259, 6204, 6205, 6184, 6185, 6147, 6148, 6163, 5735, 6270, 5733, 6268, 6267, 5741, 6279, 6278, 6280, 5752, 6286, 5773, 6295, 6294, 6293, 6296, 5783, 6300, 5778, 6299, 5670, 5671, 5665, 5667, 5666, 5688, 5689, 6067, 6068, 6055, 6057, 6056, 6077, 6079, 6078, 6032, 6033, 6086, 6087, 6088, 5873, 5874, 5851, 5852, 5807, 5808, 5481, 5482, 5515, 5516, 5489, 5508, 5510, 5509, 5492, 5493, 5593, 5594, 5461, 5462, 5472, 5473, 5412, 54505, 55006, 34507, 34703, 34718, 34695, 34734, 34694, 34744, 34707, 34706, 34750, 34743, 34739, 34702, 34713, 34716, 34710, 34698, 34745, 34701, 34719, 34757, 34760, 34770, 34769, 34729, 34775, 34717, 34728, 34742, 38438, 38439, 37846, 37847, 35087, 36722, 34880, 34881, 34916, 34917, 34874, 34875, 34931, 34932, 34967, 34968, 34887, 34888, 34922, 34923, 34905, 34906, 34895, 34896, 34950, 34951, 34960, 34961, 34972, 34973, 34920, 34921, 34981, 34982, 34943, 34944, 56266, 56198, 56336, 56298, 56199, 56391, 56368, 56252, 56384, 56191, 56174, 56365, 56190, 56297, 56382, 56226, 56364, 56223, 56178, 56273, 56215, 56371, 56383, 56354, 56188, 56167, 56235, 56220, 56242, 56248, 56243, 56390, 56249, 56185, 56350, 56372, 56239, 56259, 56355, 56189, 56327, 56315, 56168, 56177, 56351, 56392, 56225, 56173, 56373, 56345, 56311, 56385, 56224, 56379, 56318, 56238, 56376, 56314, 56282, 56206, 55919, 55922, 55921, 55924, 55920, 55923, 56142, 56143, 56145, 56147, 56146, 56149, 56144, 56148, 55902, 55909, 56157, 56159, 56161, 56158, 56160, 56397, 56400, 56399, 56402, 56398, 56401, 56082, 56083, 56088, 56084, 56086, 56090, 56089, 56092, 56087, 56085, 56091, 56412, 56415, 56416, 56419, 56420, 56417, 56418, 56423, 56424, 56413, 56414, 56421, 56422, 56425, 56426, 56427, 56436, 56437, 56428, 56429, 56432, 56433, 56440, 56441, 56438, 56439, 56444, 56445, 56434, 56435, 56430, 56431, 56442, 56443, 55811, 55816, 55817, 55814, 55815, 55820, 55821, 55812, 55813, 55818, 55819, 34452, 34122, 34123, 34124, 34097, 34240, 34127, 34128, 34110, 34111, 34220, 34221, 34222, 34120, 34121, 29436, 29437, 29438, 29439, 29440, 29441, 29442, 29443, 29428, 29429, 29432, 29433, 29434, 29435, 28914, 28915, 28923, 28924, 28874, 28875, 28876, 28903, 28904, 28869, 28870, 28927, 28928, 28929, 28918, 28919, 28920, 28901, 28902, 28841, 28842, 28843, 28829, 28830, 28852, 28906, 28911, 28910, 28908, 28907, 28838, 29077, 29054, 29119, 29052, 29274, 29214, 29149, 29144, 29324, 29097, 29107, 29386, 29034, 29379, 29359, 29201, 29235, 29191, 29215, 29053, 29155, 29094, 29333, 28740, 28741, 1187, 1055, 224 )
)
ORDER BY date_available DESC ,
FILE ASC , id ASC


---------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------
Base de datos
1664355 Fotografías (primera fotografía añadida el Jueves 07 Julio 2011)
56513 álbumes incluyendo 56513 físicos y 0 virtuales (1664355 asociaciones)
0 etiqueta (0 asociación)
44 usuarios
2 grupos
0 comentario

Offline

#2 2011-07-17 15:51:48

flop25
Piwigo Team
Registered: 2006-07-06
Posts: 5504
Website

Re: Slow Querys

Hello
thx for reporting that kind of problem. On what page this is happening ? and with what kind of plugin or config ....
We'll seriously look on that : you're not the first and that's annoying !

edit : ho it was you... please try to stop creating post for your problem Let's try to keep this one alive and up to date. thx

Last edited by flop25 (2011-07-17 16:04:09)


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

twitter facebook google+ newsletter Donate Piwigo.org © 2002-2014 · Contact