Re: queries on smi tables

In article <4od2cp$a5h@cssun.mathcs.emory.edu>, Mickey Mestel <mickey.mestel@etak.com> wrote: >hi, > has anyone else noticed that in 7.X queries on the smi tables are >incredibly slow? no matter what the load on the system, the following >query: > select dbsname from systabnames > where dbsname = "bls" and tabname = "abi"> >takes a consistent 5 minutes or so to run. considering that this pseudo-table >exists in memory, and only has a couple thousand rows, if that, *and* is >indexed, this seems really out of hand. I have seen similiar behavior in both 7.11 and 7.13. Interestingly some queries that should get all their information from shared memory seem to cause large amounts of disk I/O. For example the following query: select * from sysmaster:syslocks will cause thounds of physical reads to occur. This problem is only intermittent at our site though. -- Greg C. Faulk Database Administrator TRW Financial Systems Document Imaging Systems 300 Lakeside Drive Phone: (510) 645-3655, Fax: (510) 645-3311 Oakland CA 94612-3540 E-mail: gregf@tfs.com