Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sun-barr!apple!agate!ucbvax!hsdndev!dartvax!mermaid!tom From: tom@mermaid.Litle.Com (Tom Hampton) Newsgroups: comp.databases Subject: How many tables vcan you join in Informix? Message-ID: <544@mermaid.Litle.Com> Date: 13 Feb 91 02:02:07 GMT Reply-To: tom@mermaid.litle.com (Tom Hampton) Organization: Litle & Co. Lines: 19 We are creating a report which joins 13 tables to get at 9 fields. How may is *too* many? The report, running on a massive Encore (100+ MIP), takes about 10 minutes. The database has few rows -- that can't be it. Any ideas? -- =============================================================================== Tom Hampton, Mgr. New Technology, Litle & Co. | POB A218, Hanover, NH 03755 | +1 603 643 1832 ------------------------------------------------------------------------------- Design is figuring out what you won't be able to do. ------------------------------------------------------------------------------- tom@mermaid.litle.com {backbone}!dartvax!mermaid!tom ===============================================================================