Thread: big integer design question

big integer design question

From
"Ara Anjargolian"
Date:
Hi,
I am developing the DB code for what I hope will be
become a rather large/popular web application.  The design
uses  a unified object model, all object_ids coming from one
master sequence (suffice it to say it must be this way to meet
other design goals).
Being the worrier that I am, I am concerned that we may some
day overflow the integer currently holding the object_id.

So my question is, keeping performance and feasability in mind, would
it be better to just make all the table and cross-type index query
changes to move to a big integer from the get-go,
or would it be better to just wait to see if/when we reach say a billion on
our
ID sequence and worry about it then.

Any and all opinions, insights, and experiences on this topic would
be much appreciated.

Sincerely,
Ara Anjargolian