Re: DATA TYPES
Date: 5 Jan 1995 20:58:25 GMT
Message-ID: <3ehmhh$mdm_at_fred.uswnvg.com>
rt_at_astro.ocis.temple.edu (rt_at_astro.ocis.temple.edu) wrote:
: Which data type is most suitable for serial numbers that you expect to
: hit 100,000 and more in the course of at least 2 years. Integer is
: definately out for a column data type since it will max out and roll
: over at about 37600 something. You will get some interesting queries
: there! :-) Any suggestions?
One of my clients uses NUMBER(9,0) for quite a few years (moyabe more than 10 years) and they haven't have any problem so far. It was used to create unique ID from a common sequence generator. The application I am working with chew up more than 100,000 sequence a month! Another application uses 6-7 million of sequences every quarter (when the lookup tables gets updated -- yep, one of them is a huge lookup table).
(Whatever I say and own are mine, mine and only mine! So, don't you dare claim they are yours!)
Kim Ng
Paradigm Computer Consulting, Inc.
20611 E Bothell-Everett Hwy SE, Suite 280 Bothell, WA 98012
U.S.A. Received on Thu Jan 05 1995 - 21:58:25 CET