Subject | Re: [ib-support] Re: DB-file growth VERY rapidly!?? |
---|---|
Author | Lev Assinovsky |
Post date | 2002-02-11T18:29:49Z |
DECIMAL(x,y) means that IB stores AT LEAST x digits. If you have
more then IB allocates more. Replace DECIMAL with NUMERIC(x,y) (stores
EXACTLY x digits). And try to trace the values before update.
_a_x_e_ wrote:
Lev Assinovsky Peterlink Web
Programmer St. Petersburg, Russia
Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7�
E-mail: lev@...
[Non-text portions of this message have been removed]
more then IB allocates more. Replace DECIMAL with NUMERIC(x,y) (stores
EXACTLY x digits). And try to trace the values before update.
_a_x_e_ wrote:
> INTEGER range is too small, because the field is used to store network--
> traffic and with INTEGER only 2GB would be possible to store, but I
> can try DECIMAL(12,0) because that would be enough.
>
> --- In ib-support@y..., Lev Assinovsky <lev@p...> wrote:
> > Sure. Especially because I don't know how Perl works with int64.
> > Can you replace decimal with just an "INTEGER"?
>
> > Lev Assinovsky Peterlink Web
> > Programmer St. Petersburg, Russia
> > Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7�
> > E-mail: lev@p...
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Lev Assinovsky Peterlink Web
Programmer St. Petersburg, Russia
Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7�
E-mail: lev@...
[Non-text portions of this message have been removed]