Help: Reducing Extents

Posted in 1997

Chad Laity — Fri, 13 Jun 1997 16:45:44 -0400 — source: Informix-list mailing list archive (1991-1998)

I am running a electronic document management system (EDMS) that uses Informix 7.22 as a back end to manage the documents. The EDMS system warns me when there are database problems that slow performance. In this case it warned me that there were too many extends for the tables listed below: DBMS Tables With More Than 5 Extents # of Extents Type Name 36 Table arrowdev:dm_sysobject_s 22 Table arrowdev:syscolumns 21 Table arrowdev:dmr_content_s 19 Table arrowdev:sysviews 17 Table arrowdev:dm_sysobject_r 15 Table arrowdev:dmr_content_r 14 Table arrowdev:dmi_object 12 Table arrowdev:dm_type_r 8 Table arrowdev:sysobjstate 7 Table arrowdev:dmi_queue_item_s 7 Table arrowdev:sysconstraints 6 Table sysmaster:syscolumns How do I reduce the number of extents to improve performance?? Thanks, Chad Laity chad_laity@arrowintl.com wick@fast.net