Hi all, I just installed 7.6.0.12 on Windows (all parameters are set to their defaults) and ran some quick tests, which did the following: created a user, created tables and indices, ran the whole bunch of SQLs (several thousand) which populated and queried the data, mesuring timing of them and comparing to expected result sets. All the timings were exceptionally good, but some responses returned were different from expected ones. Not all of them - just few. I restarted PC and tried the test again - it passed well, then I dropped test user and tried it again without restarting database, and it failed, but on requests different from those which failed first time. I ran it several times after with same result - sometimes test passed, but most of the times failed. Just FYI - these tests passed fine on 7.5.0.18 and 7.5.0.30 versions of MaxDB.
>From my experience one of the reasons for such behaviour can be problem with caches. I tried to turn off SHAREDSQL as one of the suspects. And test passed well, but terribly slow (much slower then on 7.5.0.30 with SHAREDSQL=NO). I still cannot be sure 100% if SHAREDSQL is the reason, because I was reluctant to run the test several times (because it was so slow). Here are the questions: 1) Can someone think of other reasons (except SHAREDSQL), which might cause described behaviour? 2) Why is it so slow with SHAREDSQL=NO? 7.5.0.30 with SHAREDSQL=NO works way faster. Thank you in advance. Regards. Alexei. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
