On Wed, Apr 8, 2015 at 11:16 AM, Jeff Roux <jfroux06 at gmail.com> wrote:
> # For mysql, I use: > /etc/init.d/mysql stop; /etc/init.d/mysql start; \ > time echo 'SELECT SUM(nbBytesDecompOut+nbBytesCompIn) as vol, portLan \ > as item FROM flows WHERE timestamp>=1383770600 AND \ > timestamp<=1384770600 AND protocol IN (17, 6) GROUP BY portLan \ > ORDER BY vol DESC LIMIT 6;' | > mysql testperf > If you dropped the LIMIT 6 from both, are the results significantly different? I.e. does actually getting the full result set result in closer numbers between SQLite and MySQL? I'm not sure SQLite's implementation of LIMIT prevents the whole result-set from being sorted before being truncated to 6 rows. Avoiding LIMIT would be one round-about way to find out. --DD
