Val Posted April 24, 2013 Report Share Posted April 24, 2013 ko rāda? SHOW INDEX FROM a Quote Link to comment Share on other sites More sharing options...
marrtins Posted April 24, 2013 Report Share Posted April 24, 2013 pilnīgi neko nedeva. a tabulai expleins norāda null possible keys! Pamēģini bez tā id - a.c,a.e Quote Link to comment Share on other sites More sharing options...
aika Posted April 25, 2013 Author Report Share Posted April 25, 2013 tagad paņēma to indexu: ieguvām ~0.7s. acīmredzot tas ir max ko var izdarīt! bet mācība skaidra: id laukus neveidojam varcharos, indexsējam arī order laukus, izvairamies no select * plds. Quote Link to comment Share on other sites More sharing options...
spainis Posted April 25, 2013 Report Share Posted April 25, 2013 a.u_id, , a.c, a.e? Quote Link to comment Share on other sites More sharing options...
marrtins Posted April 25, 2013 Report Share Posted April 25, 2013 acīmredzot tas ir max ko var izdarīt! Nu gan jau vēl var pietūnēt mysql parametrus. Quote Link to comment Share on other sites More sharing options...
aika Posted April 25, 2013 Author Report Share Posted April 25, 2013 a.u_id, , a.c, a.e? + ~0.3s Quote Link to comment Share on other sites More sharing options...
spainis Posted April 25, 2013 Report Share Posted April 25, 2013 ka ir ar lauku unikalitati? Quote Link to comment Share on other sites More sharing options...
aika Posted April 25, 2013 Author Report Share Posted April 25, 2013 a.u_id varchar 32 pats par sevi unikāls, bet a tabulā var atkārtoties a.c int(1) a.e datetime Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.