> >Hi! > > Please reply to the list, not to me personally, so that others can > follow this discussion. Thanks. >
Sorry, > > > > > > > >> At 13:21 +0200 11/21/03, Jozsa Boti wrote: > >> >Hi! > >> > > >> >How an i get the last Check-time of a specific table without using LIKE > >> >statements? > >> > >> There isn't another way. > >> > >> >There's the SHOW TABLE STATUS command, but if there are many tables in a > >> >database this command is very slow, even if a specific table name is > >after > >> >the LIKE statment. > >> > >> Slow? How many tables are we talking about? > >> > > > >I'm talking about nearly 20 000 tables in a database. > >In this case a SHOW TABLE STATUS commande takes about 20-30 seconds. > > Hm, that is pretty slow. How long does an "ls" command in the database > directory take? > About 1-2 seconds. Boti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
