min() and max() can use indexes so they shouldn't be slower.
On Mon, 14 Feb 2005 17:13:07 -0700, Ryan McCullough
<rmccullough@stripped> 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 <eric.bergen@stripped> 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 <zwang@stripped> 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/mysql?unsub=1
> > >
> > >
> >
> > --
> > Eric Bergen
> > eric.bergen@stripped
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=1
> >
> >
>
>
> --
> Ryan McCullough
> mailto:rmccullough@stripped
>
--
Eric Bergen
eric.bergen@stripped
http://www.ebergen.net
