On Tue, 2005-03-15 at 13:55 +0100, Thomas Mueller wrote: > Hi Aaron, > > > On MySQL: > > 4543 rows in set (0.28 sec) > > 41573 rows in set (1.69 sec) > > > > So if this fixes it for Pg, then I think we've got a winner :-) > > 'in set' means 4543 results? Is there something like explain analyze in > MySQL too?
You won't like it :) http://netmirror.org/mirror/mysql.com/doc/mysql/en/explain.html shows its format. It's not fun to read (only slightly more fun than reading SQLite's output) > Could you please post results? > 0,04 ms per result in case of the 42k rows - that sounds like a > in-memory database. My entire dbmail db is only about 50M per 12k messages; I can easily fit 42k messages into buffer-space. -- Internet Connection High Quality Web Hosting http://www.internetconnection.net/
