Re: systables doubt

From: gmurad@unimedsp.com.br > >From: gmurad@unimedsp.com.br > > > >Guys, there's something really strange with my Database... > > > >Im having performance problems after upgraded to DSA 7.30. > >After debugging (onstat -g sql XX) some 4gl programs, we found one table > >with 7 rows, that when you run select count (*) from dbaccess on this > >table, it takes about 20 seconds...but if i run this command on the > >customers table (400.000 rows), it respond imediatly... > >the same happens if you ask for the table status from dbaccess... > >Is there anything wrong with my systables? > > > >If anybody had such experience, i would apreciate any information. > >Interesting. Have you run update statistics lately? > >Yes i did!! and right before testing the select above.. >i also dropede and recreated the table, and id goes better for a couple of >hours.. >but then goes slow again.. That *is* weird. Can you try running the count with SET EXPLAIN ON just after the recreate and again when it's going slow? Also, anything funny in your online.log? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com