Re: Size of dbexport

Hi Russ, Thanks very much for your reply. Basically when I first wrote this I put maximum ascii sizes for ints, smallints and floats. This came out with a maximum size that was 100% to large. I then tried selecting max from these columns. This would work, the only problem is that it does a sequential scan on each value. On a database of this size that was taking hours and this is for an upgrade process to upgrade live client sites where minimul down time is critical. AVG would have been a good estimation but again I would have the time constraints when upgrading live sites. What I did in the end was scalled down my binary data factors based on the data in a client database. Now it's comming out about 20% over. This is fine as it allows for an increase in data density. Once again, thanks very much for your responce. Kind Regards Sean On Jan 26, 4:34pm, Russ_Evans@doh.state.fl.us wrote: > Subject: RE: Size of dbexport > I haven't done it, but you might try selecting the AVG from the numeric > column and using the ascii length of that in your calculation. Not exact, > but probably close enough for government work. > > > > -----Original Message----- > > From: Sean Galvin [SMTP:sgalvi01@cork.cig.mot.com] > > Sent: Tuesday, January 26, 1999 1:26 PM > > To: informix-list@iiug.org > > Subject: Size of dbexport > > > > At present I am trying to put together a script that accurately works > > out the size of a dbexport. > > > > The problems (fun and games) arrive when you start to work out the size > > of smallints, ints etc. (e.g. binary data). > > > > It's easy enough to work out the max. ascii size of these but this > > provides me with an estimate that is far to high although it is the > > theoretical max. value. > > > > Has any one written a script in the past to do this that they can send > > me. > > > > It would be very much appreciated. > > > > Regards > > > > > > > > > > Sean > > > > > > -- > > > > ======================================================= > > //////////////// Sean P. Galvin > > ////////// // Senior Consultant > > ////// / /// Informix Software Ltd. > > ///// // //// > > //// // ///// Office: +353 (0) 21 511744 > > /// // ////// Home : +353 (0) 21 508265 > > // // /////// Mobile: +44 (0) 585 466408 > > / /////////// Email : sgalvi01@cork.cig.mot.com > > //////////////// WWW : http://www.informix.com >-- End of excerpt from Russ_Evans@doh.state.fl.us -- ======================================================= //////////////// Sean P. Galvin ////////// // Senior Consultant ////// / /// Informix Software Ltd. ///// // //// //// // ///// Office: +353 (0) 21 511744 /// // ////// Home : +353 (0) 21 508265 // // /////// Mobile: +44 (0) 585 466408 / /////////// Email : sgalvi01@cork.cig.mot.com //////////////// WWW : http://www.informix.com