search

jwong-d2l / sessionweb

Automatically exported from code.google.com/p/sessionweb
1 stars 0 forks source link

Edit/view session takes a long time to load #128

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
When sessionweb db gets larger the edit/view session takes a very long time to 
load.

Reason. Missing index on table softwareuseautofetched

How to Solve:
ALTER TABLE `sessionwebos`.`softwareuseautofetched` ADD INDEX `versionid` 
(`versionid` ASC);

Original issue reported on code.google.com by mcyr...@gmail.com on 26 Nov 2012 at 10:52

GoogleCodeExporter commented 8 years ago

Original comment by mcyr...@gmail.com on 26 Nov 2012 at 10:52