On 11/1/05 2:38 PM, "Jim C. Nasby" <[EMAIL PROTECTED]> wrote: > > FWIW, most databases I've used limit NUMERIC to 38 digits, presumably to > fit length info into 1 or 2 bytes. So there's something to be said for a > small numeric type that has less overhead and a large numeric (what we > have today).
The 38 digit limit is the decimal size of a 128-bit signed integer. The optimization has less to do with the size of the length info and more to do with fast math and fixed structure size. J. Andrew Rogers ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly