hammackj/risu — Issue #51: SQLite versus MySQL performance
Author: emory
Created: 2012-01-31 21:32:04+00:00
State: open

I don't know if there are optimizations that can be done to risu or with sqlite, but there is a large discrepancy between the two when it comes to report generation, importing of data, and other operations involving stored data.

Anecdotally I have a 9.5MB .nessus archive that I fed to risu.

sqlite: 44 minutes
mysql: 84 seconds

Workstation is a MacMini5,3 (i7 quad-core) with 8GB of RAM running Mac OS X. It doesn't appear to be CPU-bound or io-bound so I'm not sure why it's slow, but it is much faster on MySQL than SQLite.