Hi, Tried that on a few tables, all i get is "0 rows affected" and a time.
Maybe it is the way I upgraded the database? Rana On Monday 11 September 2006 14:20, Jey Razack wrote: > try to perform 'UPDATE STAT <TABLE NAME> ....' on each table. > on huge tables use the 'ESTIMATE SAMPLE nn PERCENT' option. > > -Jey > > -----Original Message----- > From: Ranadave Mukherji [mailto:[EMAIL PROTECTED] > Sent: Monday, September 11, 2006 6:28 AM > To: maxdb@lists.mysql.com > Subject: Moving from version 7.5 to 7.6 > > > Hi, > > I have recently upgraded my MaxDB installation from 7.5 to 7.6 on linux. > But now the access times have shot up astronomically. We are talking about > .6ms on 7.5 vs 30sec on 7.6. > > I have tried reloading the system tables. Do I need to rebuild anything > else? or am I meant to reconfigure something? > > Can anyone point me along the right direction? Any help appreciated. > > > Rana > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]