RE: Whatcha' wanta have?????

Hi, Madison, It would be nice to see the following two features in IDS9.6: 1. Ability to manage FIRST/NEXT extent size for index. Extent size is a very big problem for big tables, containing LVARCHAR. For such tables, index extent size, calculated by Informix automatically, becomes too small, and the table might easily run out of extents for the index partition while it has just few extents in the data partition 2. Ability to PURGE all data from a table in a single unlogged operation. Current workaround is to drop the table and create it again, which is sometimes not possible. PURGE should be considered DDL, not DML statement, and should be non-recoverable. PURGE should also release all unused table extents except the initial extent. Best regards, Alexey Sonkin -----Original Message----- From: Madison Pruet [mailto:mpruet@comcast.net] Sent: Friday, February 06, 2004 6:41 PM To: informix-list@iiug.org Subject: Whatcha' wanta have????? As a mild diversion from the IDS-DB2 conversion thread, its time for one of my more favorite exercises. ;-) We are nearing the end of the coding cycle for IDS 9.5. We've got a whole bunch of really cool stuff in place and - well - its time to get input from you guys as to what you want to see in the 9.6 release. Now, I know that everyone's favorite thing is going to be "marketing", but I'm in development. So I need to talk features and functionality. So feel free to send them on in. Just an FYI - I'll be away for a while and won't be able to get email via my comcast email address. But, I'll be following the newsgroup rather closely. Also, next week I'll be in some planning meeting. So getting responses back fairly quickly would really help. Thanks M.Pruet sending to informix-list sending to informix-list