Potential SQL performance improvement

[RamblinWreck77]

Version: 4.0.4

Seemed different enough from #584 to warrant its own issue, but I also noticed this in the disk report section:

Code:

[weibel]

On our app the disk write report shows that Mixpanel consumes in total 48% across several traces

[RamblinWreck77]

@zihejia This is the majority of our disk usage and we send a relatively small number of events. Could we potentially get this optimized in the next few weeks? Again I'm not an SQL expert but it seems like adding an index is relatively straightforward?

[jaredmixpanel]

@RamblinWreck77 @weibel The Apple docs say...

The Disk Writes Report pane suggestions identify queries that may benefit from an index.

The Disk Writes Report pane suggests using write-ahead logging when a stack trace indicates a different journaling mode.

Are either of you seeing those suggestions or any others? I am going to look into this and see what we can do.

EDIT: Ah, I see the screenshot above does suggest an index.

[jaredmixpanel]

@RamblinWreck77 @weibel I've released v4.1.1 which adds an index and enables WAL journaling mode. I'm going to close this for now. Feel free to re-open if the issue persists.

[RamblinWreck77]

@jaredmixpanel FWIW, this one update (mixpanel update was the only change) has reduced our disk writes MB/day to 1/5th the previous value