systables doubt

Posted in 1999

gmurad@unimedsp.com.br — Wed, 15 Sep 1999 14:43:22 -0300 — source: Informix-list mailing list archive (1991-1998)

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. TIA, Gustavo Murad

Related threads

Posting from the Informix-list
Migrating from IDS 9.40.UC6 to 11.50.UC3
Ip for a network session
questions onstat -g