I suggest turning on the DB Analizer Trace and then inspect the generated log, it will contain several warnings about what's not working well with your current configuration.
http://dev.mysql.com/doc/maxdb/en/2b/361e3bd129be04e10000000a114084/frameset.htm There are also some new parameters that affect JOIN performance, you may want to check their values to see if their defaults are appropiate for your case, but I would recommend this AFTER using the analyzer. Maybe you already read this, but in case you have not, here is the link to the performance how-to for maxdb: * http://dev.mysql.com/tech-resources/articles/maxdb-performance-primer.html Hope it helps. Best regards, Martin Cordova -- Dinamica - RADical J2EE framework open source, easy and powerful http://www.martincordova.com On 1/11/06, Manuel Reiter <[EMAIL PROTECTED]> wrote: > Ja, we updated the statistic, but without any result. > Can you refer any tuning specialist or anyone who could help us with > this matter ? > PS: we are in Austria. > > > Döhr, Markus ICC-H schrieb: > > >>Hi we migrated from SAPDB 7.3 (32Bit Linux) to MAXDB 7.6 (64 > >>Bit Solaris). > >>So far so good. > >>We exerience some request beeing faster than before but most > >>of the requests that work with multiple tables much slower > >>than before. > >>Any optimization gurus aou there ? > >> > >> > > > >Did you update the statistics of the database? > > > > > >Greetz, > > > >SIEGENIA-AUBI KG > >Informationswesen > > > >i.A. > > > >Markus Döhr > >SAP-CC/BC, SAPDB-DBA > > > >Tel.: +49 6503 917-152 > >Fax: +49 6503 917-7152 > >E-Mail: [EMAIL PROTECTED] > >Internet: http://www.siegenia-aubi.com > > > > > > > > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
