Am 24.10.2013 12:20, schrieb Daniel Schütze: > The simple query select count(*) from dbmail_fromfield; takes 8seconds on > the new and 3 seconds on the old.
makes no sense to measure anything but disk speed http://www.mysqlperformanceblog.com/2006/12/01/count-for-innodb-tables/ > A scan query of select * from dbmail_fromfield where fromfield like > "%EXAMPLE%"; takes 9 seconds on the new and 3.3 seconds on the old. is a query not using indexes > Also of course these are not queries which dbmail actually performs when it > is running for real they are generally useless examples, see above > and I have read dbmail 5.1 is faster for single threaded queries what is a "single threaded query"?
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
