Search the web
Sign In
New User? Sign Up
baseball-databank · Baseball Databank
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
SCHEMA - Oversized MySQL fields?   Message List  
Reply | Forward Message #3613 of 3878 |
Re: [baseball-databank] Re: SCHEMA - Oversized MySQL fields?

Regarding the tinyint and int and the like issue: I disagree. I'll give
you two good reasons:

1. An 8 GB flash drive costs $29. A 500 GB backup drive costs 75$.
Saving space should be the least of our concerns. Indeed, I'd prefer
creating a data warehouse, which would mean heaving denormalized data.

2. If you do sum(wins) on a tinyint, some DBMS will keep the data type as
tinyint. You will get into overflow situations.

Whatever performance issues you can possibly gain pales in comparison to
potentially corrupt output.

Tom




Wed Oct 22, 2008 1:05 am

tom@...
Send Email Send Email

Forward
Message #3613 of 3878 |
Expand Messages Author Sort by Date

I realize that this is a relatively minor detail in relation to some of the other things being planned here, but I've noticed that the current MySQL schema has...
Randy Fiato
rfiato
Online Now Send Email
Jan 1, 2003
12:02 am

... some of the ... MySQL ... fields are ... range of ... int(4), ... as yearID ... Similarly, ... of ... season (or ... of 0 - ... playing ... been able ... ...
wyerscj
Offline Send Email
Oct 19, 2008
12:00 pm

... If the nature of the data is that it is unsigned, it should be stored in an unsigned column. If the nature of your application is that you use the values...
Paul DuBois
pdubois20
Offline Send Email
Oct 19, 2008
4:48 pm

... Anything in baseball that could possibly be a negative number?...
James
emiduplam
Offline Send Email
Oct 21, 2008
9:45 pm

Regarding the tinyint and int and the like issue: I disagree. I'll give you two good reasons: 1. An 8 GB flash drive costs $29. A 500 GB backup drive costs...
Tangotiger
tom@...
Send Email
Oct 22, 2008
1:20 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help