Re: Informix .dat & .idx file sizes

"131AC0000-BasuA(DR2783)231" <abasu@dr.lucent.com> wrote: :Here's is an Informix SE (on Solaris 2.4) question: :Is there a way to get the maximum file size for the informix :.idx file, given an upper limit on the number of rows in the :table? (the indexes and their compositions are also known). :Any help will be greatly appriciated. Replies may be posted or mailed :to me at abasu@drmail.dr.lucent.com I don't know your prices for new disks, but ours cost about 5 working hours per gigabyte. At this cost it soon becomes substantially cheaper to add disks than to calculate file sizes. If your problem is that the file size might increase beyound the 2 Gb limit, the SE engine probably can't handle the data efficiently anyway. Otherwise the easiest way is to insert 1000 records in you table, check the file size and multiply as appropriate for the number of rows you expect. Of course this will be off due to increasing number of index levels, fill factors and possibly other issues, but probably not to far to be usefull. To check it further you might want to insert more rows. Any further attempts at calcualtions are too costly to my mind. Nils.Myklebust@idg.no <- New E-mail adress NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company