On Wednesday 17 November 2004 11:19, Nando Dessena wrote:

> Helen,
>
> >>If the max value of the current_connection is reached, is it set
> >>to 1 again?
>
> H> Yes. I recall that someone calculated that, at 100 connections per
> second, H> 24/7, it would take about 70 years to reach the maximum.
>
> since it's an integer, at that rate you are going to overflow in
> slightly more than 1.36 years. This is assuming it is unsigned. If it's
> signed instead, as the docs seem to suggest, and if it starts from 0
> and not from -2.147.483.647 then you only have 0.68 years.
>

Has it really taken you a week to work that out?

<g, d & r>

Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase