| *** diablo_rojo has quit IRC | 04:44 | |
| *** udesale has joined #storyboard | 05:36 | |
| *** tosky has joined #storyboard | 07:35 | |
| brtknr | why is storyboard so slow? | 08:18 |
|---|---|---|
| SotK | brtknr: the current thinking is that we have some inefficient queries, not helped by the near-complete lack of sensible indexing on the database | 08:45 |
| SotK | we're currently waiting for someone (probably me) to have some time to generate a big test dataset and actually address those issues | 08:46 |
| brtknr | how big is the current DB SotK? | 08:46 |
| SotK | we have 27873 stories with 38366 tasks in total | 08:50 |
| brtknr | SotK: that doesn't sound like a lot | 09:30 |
| brtknr | what is the DB backend? | 09:30 |
| SotK | yeah, depressingly small given the performance | 09:32 |
| SotK | we use mysql with (I think) innodb as the storage engine | 09:32 |
| fungi | we've got slow query logging enabled and reporting some very inefficient compound queries, so that's a likely suspect | 10:07 |
| *** udesale_ has joined #storyboard | 10:36 | |
| *** udesale has quit IRC | 10:38 | |
| *** ianychoi has quit IRC | 12:55 | |
| *** udesale_ has quit IRC | 16:33 | |
| *** tosky has quit IRC | 23:06 | |
Generated by irclog2html.py 2.17.2 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!