data distribution cache

Posted in 2000

James Namenek — Wed, 23 Aug 2000 15:13:27 GMT — source: Informix-list mailing list archive (1991-1998)

All: System info: - Informix 2000 9.21.FC1 - Baan IVc3 - HPUX 11.00 - DB 280 GB . 30,000 tables "12 Baan companies" I'm currently running DD_HASHSIZE 511 DD_HASHMAX 50 Considering DS_HASHSIZE 511 DS_POOLSIZE 2400 The following query yields about 200 tables... select count(*) from sysmaster:sysptprof a, baan:systables b where a.tabname = b.tabname and b.tabid > 99 and a.isread > 500000 regards Jim Namenek Diebold Inc. Phone: 330-490-5929 Fax: 300-490-5735 Email: namenej@diebold.com Email: namenej@hotmail.com Please respond to namenej@hotmail.com. IIUG is delaying my email because our business mail server contains a bad phrase. "read backwords" -10hcxesm- " :-) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com