Red Mosquito • View topic

$úñ_DëV|L · **Posted:** Wed Dec 12, 2007 7:44 pm

Right now, GD has over 733,890 posts.

The field in the database that stores the number of posts can only store integers up to 16,777,216. So on the 16,777,217th post, the number of posts in GD will roll over to 0.

Any bets on when this will happen? We're already 4.4% of the way there!

malice · **Posted:** Wed Dec 12, 2007 7:45 pm

so roughly one percent per year?

McParadigm · **Joined:** Sun Oct 17, 2004 3:07 pm **Posts:** 12393

Any moment now...

dirtyfrank0705 · **Posted:** Wed Dec 12, 2007 7:54 pm

I'll be dead and buried by the time that happens.

denverapolis · **Posted:** Wed Dec 12, 2007 7:56 pm

when CB hits 100k

$úñ_DëV|L · **Posted:** Wed Dec 12, 2007 7:56 pm

malice wrote:

so roughly one percent per year?

But if we post 96 times as much throughout the next year, we could roll over by next Christmas.

malice · **Posted:** Wed Dec 12, 2007 8:32 pm

$úñ_DëV|L wrote:

malice wrote:

so roughly one percent per year?

But if we post 96 times as much throughout the next year, we could roll over by next Christmas.

isn't this the premise behind the thread about nothing?

denverapolis · **Posted:** Wed Dec 12, 2007 8:40 pm

is this some sort of challenge?

malice · **Posted:** Wed Dec 12, 2007 8:46 pm

denverapolis wrote:

is this some sort of challenge?

he's going to start deleting entire pages from your thread, dude.

I can feel it.

denverapolis · **Posted:** Wed Dec 12, 2007 9:00 pm

BadMusic · **Posted:** Wed Dec 12, 2007 10:50 pm

will it really roll over ? won't you just get a duplicate entry for key sort of error ?

conoalias · **Joined:** Fri Sep 02, 2005 5:20 am **Posts:** 31173

BadMusic wrote:

will it really roll over ? won't you just get a duplicate entry for key sort of error ?

war!

$úñ_DëV|L · **Posted:** Wed Dec 12, 2007 11:18 pm

BadMusic wrote:

will it really roll over ? won't you just get a duplicate entry for key sort of error ?

Actually, it looks like mysql will prevent overflow by simply storing the largest possible value... So it would just cap off if you try to enter a number too big for the database.

If the integer size is set up to be smaller than that in PHP, though, it might still roll over since the actual calculation is probably made in the script. I'll have to find out with the integer size is set for on the server. :idea:

noaheb · **Posted:** Thu Dec 13, 2007 2:43 am

ummm...2010

dirtyfrank0705 · **Posted:** Thu Dec 13, 2007 2:47 am

Sun Devil ftw.

Mickey · **Posted:** Thu Dec 13, 2007 2:49 am

Once God takes a shit on GD.

px · **Joined:** Wed Nov 30, 2005 4:38 am **Posts:** 18049

$úñ_DëV|L wrote:

BadMusic wrote:

will it really roll over ? won't you just get a duplicate entry for key sort of error ?

Actually, it looks like mysql will prevent overflow by simply storing the largest possible value... So it would just cap off if you try to enter a number too big for the database.

If the integer size is set up to be smaller than that in PHP, though, it might still roll over since the actual calculation is probably made in the script. I'll have to find out with the integer size is set for on the server. :idea:

if your database field for the post count integer is set to MEDIUMINT, check if the board software allows you to change the field type to BIGINT.

Or for the sake of seeing how the database would handle such a roll over, it would be kind of experimentally fun to leave the default (if it is the default) field type as is. :mrgreen:

in other news....

http://www.thinkgeek.com/tshirts/sysadmin/344f/

I think I aced my Unix/linux OS final exam today. :thumbsup:

*beer before bed*

dirtyfrank0705 · **Posted:** Thu Dec 13, 2007 3:08 am

Px is marinated in hotness.

px · **Joined:** Wed Nov 30, 2005 4:38 am **Posts:** 18049

dirtyfrank0705 wrote:

Px is marinated in hotness.

*basks in the glory of this truthiness*

noaheb · **Posted:** Thu Dec 13, 2007 3:16 am

id like to get that on my steak!
mmmmm tasty marinade for sure :luv:

When will GD roll over?

Who is online