To put that in perspective a little, at a row consumption rate of 1
million a day it'll take approx 5.88 years to hit the limit.
Comfortably out of range you might think but I'd sure hate to be the
one to alter such a colossal table when the time came. And there are
tables out in web land that hit these kind of figures - take some of
the larger social networking sites for example. In a sizable system
where perhaps there are multiple web servers to handle the traffic
along with replication etc, it's likely that time until overflow will
be greatly reduced.
Being able to specify an ID of BIGINT (bigserial in Postgres) would
be one less thing to worry about.
Justin
On 1 Apr 2006, at 08:17, Jeremy Fitzhardinge wrote:
Jaime Wyant wrote:
Currently I have about 1.7 million rows in there. SQLObject
created the `id' column for the table as `int'. MySQL's int has a
value from |-2147483648| |to 2147483647. |I suspect that I'll be
at the maximum INT value shortly. Is there an `easy' way to reset
the ID column to use BIGINT? I suspect I'll have to regenerate
the models, somehow specifying the id, but I'm not sure.
You've used about 1/1200th of your PK ID space. Are you really
generating records at such a rate that this is a concern? If so,
simply switching to unsigned isn't going to buy you much time.
J
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language
that extends applications into web and mobile media. Attend the
live webcast
and join the prime developer group breaking into this new coding
territory!
http://sel.as-us.falkag.net/sel?
cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
