Re: acceptable number of extents?

At 05:57 PM 13-08-98 GMT, mdevlin8648@my-dejanews.com wrote: >our database has over two hundred tables, 9 of them have more than one hundred >extents and another 35 have over 10. how signifigantly could this impact >performance? I am new to informix and attempting to tune our configuration. >Any help would be appreciated. Funny you should phrase it that way. My usual rant is to wonder why this kind of question isn't answered in the logical place to look: TFM "Administrator's Guide". Since you mentioned performance, you may now be fairly castigated for not looking in TFM "Performance Guide", where it can be found in the discussion on extents in chapter 4. Let me take this opportunity to brag about Informix's documentation, which is *well* worth the time to read. It's the best in the business. Informix has now made its documentation available via the web site without even downloading it (in addition to the hard copy and on CD-ROM) at http://www.informix.com . Its link is on the top-level page. _____________________________________________________________ Clem Akins (aka clem@informix.com) Menlo Park x5937 Customer Course Development Informix Software, Inc Last seen: Riding the waves of a 5.3 California earthquake!