Timeline for MySQL MyISAM table performance... painfully, painfully slow
Current License: CC BY-SA 2.5
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 10, 2009 at 0:14 | comment | added | Andomar | Your comment above says performance got better with a 1:1 table. That really seems to suggest the index on (pageid,sourceid) was clustered in some way. Oh well... problem solved I guess. | |
| May 9, 2009 at 10:47 | comment | added | Salman Arshad | I tried creating a two column index (pageid-sourceid) on the page table in order to create a short-circuit between userdata and pagesource which reduced execution time but not much. | |
| May 9, 2009 at 9:08 | history | answered | Andomar | CC BY-SA 2.5 |