G'day, Yes - but that isn't for me as a user of MySQL to have to worry about - the developers are the ones concerned about the internals. I only need to use x amount of space, and so I only choose to use x about of space not x+y amount if I can help it.
Hrmm... Ask a simple question - get criticisism for choice of implementation. Regards, Michael S. E. Kraus Software Developer/Technical Support Specialist Wild Technology Pty Ltd [EMAIL PROTECTED] Direct Line 02-8306-0007 ________________________________ ABN 98 091 470 692 Level 4 Tiara, 306/9 Crystal Street, Waterloo NSW 2017, Australia Telephone 1300-13-9453 | Facsimile 1300-88-9453 http://www.wildtechnology.net The information contained in this email message and any attachments may be confidential information and may also be the subject of client legal - legal professional privilege. If you are not the intended recipient, any use, interference with, disclosure or copying of this material is unauthorised and prohibited. This email and any attachments are also subject to copyright. No part of them may be reproduced, adapted or transmitted without the written permission of the copyright owner. If you have received this email in error, please immediately advise the sender by return email and delete the message from your system. -----Original Message----- From: Benno [mailto:[EMAIL PROTECTED] Sent: Monday, 18 October 2004 12:14 PM To: Michael Kraus Cc: Benno; Robert Collins; Glen Turner; [EMAIL PROTECTED] Subject: Re: [SLUG] Maximum process ID On Mon Oct 18, 2004 at 11:56:02 +1000, Michael Kraus wrote: >G'day... > >Not necessarily, MEDIUMINT is probably (I don't know I haven't checked >the code) stored as its own defined type, and may be stored differently >on disk and in memory than an INT value (which is 2^32). Well, I'm sure it is stored differently on disk, but in memory it is going to be an int. Unless they want things to be really slow. >I expect that MySQL has either implemented some difference and hence >that is why they provide a variety of data structures. Being the good >database student that I was, I'm wanting to use the most appropriate >integer structure for my purpose. > >The base data types implemented in a language (in this case we are >referring to C, however I can't say if MySQL is programmed completely >in C, but I could take a look at the source if I really needed to know) >influence rather than dictate the data types used by the program >(MySQL). (Especially when we are talking about C as it's a language >that allows you to define your own datatypes and how they are handled.) Well, since sizeof(pid_t) gives you 4, why not use an int in your database? Benno -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
