Search the Community
Showing results for tags 'guru needed!'.
Found 1 result
-
problēma: esošais (acīmredzot patizlais) pieprasījums pārsniedz 5s. SELECT * FROM a INNER JOIN b ON b.id = a.id LEFT JOIN c ON c.id = b.c_id WHERE a.u_id = 'f53c6deff44e23439d2b84d26820cec9' ORDER BY a.c, a.e LIMIT 0, 25; kā, lūdzu, nooptimizēt?! a tabula ~ 10K, b tabula ~ 50k, c tabula ~ 100 ierakstu. visi id varchar(32) ar indeksiem paldies jau iepriekš!
