I wish I had the numbers still. But, in all it was maybe 5% - 10% more
storage for 10 million rows of integers.
Brian.
--------
http://brian.moonspot.net/
On 7/30/09 2:01 PM, Jeremy Zawodny wrote:
That's primary storage, right? What about indexes?
Jeremy
On Thu, Jul 30, 2009 at 11:16 AM, Brian Moon <[email protected]
<mailto:[email protected]>> wrote:
The thing I also found interesting was that (in INNODB anyway) the
storage needs for a BIGINT are not really that much larger than INT.
So, I am just using BIGINT these days anyway. I forget what the
numeric data types for Drizzle are. Was there just INTEGER?
Brian.
--------
http://brian.moonspot.net/
On 7/30/09 1:05 PM, Brian Aker wrote:
Hi!
The plan is to implement SERIAL as a real type which would what
you are
asking for (the code for signed/unsigned was more then a little
bit of a
mess).
Are you looking for an OID?
Cheers,
-Brian
On Jul 30, 2009, at 9:08 AM, Tim Soderstrom wrote:
I know there was a conversation about this on the list
before but I
was curious as to the outcome? I just built Drizzle from the
latest
version as of yesterday and 'int unsigned' no longer works.
I know
there was a big movement behind removing mediumint but I
can't see how
signed/unsigned would fall into that category? 2 billion is
big, but 4
billion is a hellofalot bigger :)
Just curious.
Tim
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
<https://launchpad.net/%7Edrizzle-discuss>
Post to : [email protected]
<mailto:[email protected]>
Unsubscribe : https://launchpad.net/~drizzle-discuss
<https://launchpad.net/%7Edrizzle-discuss>
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
<https://launchpad.net/%7Edrizzle-discuss>
Post to : [email protected]
<mailto:[email protected]>
Unsubscribe : https://launchpad.net/~drizzle-discuss
<https://launchpad.net/%7Edrizzle-discuss>
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
<https://launchpad.net/%7Edrizzle-discuss>
Post to : [email protected]
<mailto:[email protected]>
Unsubscribe : https://launchpad.net/~drizzle-discuss
<https://launchpad.net/%7Edrizzle-discuss>
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
