SQLBlog.lv Posted April 24, 2012 Report Share Posted April 24, 2012 Zvaigznīte izskatās visai slikti.. Pamatīgu iespaidu (ātrdarbībai par sliktu) noteikti atstāj order by.. Un vēl derētu paskatīties, vai tiešām datu tipi abās tabulās ir identiski.. Quote Link to comment Share on other sites More sharing options...
F3llony Posted May 1, 2012 Report Share Posted May 1, 2012 (edited) APC/Memcache/Couchbase/Xcache/Wincache. Ja 35K selects no 2 tabulām ilgst >2s, tad jādomā par 1. Dzelžu upgreidu. Steidzami. 2. Datu kešošanu. Sekundāri. 3. Indeksi salikti korekti? Edited May 1, 2012 by F3llony 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.