min() and max() can use indexes so they shouldn't be slower.
On Mon, 14 Feb 2005 17:13:07 -0700, Ryan McCullough <[EMAIL PROTECTED]> wrote: > what about other functions like doing a min() or max()? are those slow > limitations of innodb tables as well? > > > On Mon, 14 Feb 2005 15:52:21 -0600, Eric Bergen <[EMAIL PROTECTED]> wrote: > > Total row count is cached in the header for MyISAM tables. InnoDB has > > no such mechanism for this because transactions make it impossible to > > keep an exact row count. In order for InnoDB to get a row count it > > has to do a full scan inside a transaction which will take a long > > time. One way around this is to maintain row count in another table. > > > > For show table status it's better to only check the tables you need. > > Example: show table status like 'my_table' > > > > I'm not aware of any plans to speed up either of these commands on InnoDB. > > > > > > On Mon, 14 Feb 2005 12:06:09 -0500, Zhe Wang <[EMAIL PROTECTED]> wrote: > > > Hi, there, > > > > > > I am in the middle of replacing a MyISAM database with InnoDB. > > > Queries "show table status" and "select count" are extremely slow which > > > gave me some pain. I am wondering if there are any other queries on > > > InnoDB that are significantly slower than those on MyISAM other than > > > these two? And does MySQL have any plan to speed up this kind of queries? > > > > > > Thank you very much in advance for your reply! > > > > > > Regards, > > > Zhe > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > -- > > Eric Bergen > > [EMAIL PROTECTED] > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > Ryan McCullough > mailto:[EMAIL PROTECTED] > -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
