Re: mySQL data types - possible db bloat with text type? yes or no?

2010-09-03 Thread Michael Grant
*bump* No one has any insight into this? Please please please. On Thu, Sep 2, 2010 at 11:47 AM, Michael Grant mgr...@modus.bz wrote: Normally I use MSSQL but the shop I'm at uses mySQL. I've always built my db's so that the field best matches the data going into it. As an example if I was

Re: mySQL data types - possible db bloat with text type? yes or no?

2010-09-03 Thread Russ Michaels
With MSSQL you are limited to about 8000 bytes per row and anything beyond this will be chopped, so you need to be careful how much data you are storing. Using BLOBS will overcome this as a pointer to the blog is the only thing stored in the row, and the blog is actually stored separately. Using

Re: mySQL data types - possible db bloat with text type? yes or no?

2010-09-03 Thread Won Lee
On Fri, Sep 3, 2010 at 12:04 PM, Michael Grant mgr...@modus.bz wrote: *bump* No one has any insight into this? Please please please. On Thu, Sep 2, 2010 at 11:47 AM, Michael Grant mgr...@modus.bz wrote: Normally I use MSSQL but the shop I'm at uses mySQL. I've always built my db's so

Re: mySQL data types - possible db bloat with text type? yes or no?

2010-09-03 Thread Michael Grant
Thanks. Other than the 1 extra byte thing... if I'm using MyISAM and assumming I have a string that's 150 characters is there any advantage to using varchar(150) over say TEXT or any of the other text type fields? that's what I'm trying to get at. So is a table that's got 20 TEXT datatype fields

Re: mySQL data types - possible db bloat with text type? yes or no?

2010-09-03 Thread Won Lee
On Fri, Sep 3, 2010 at 12:23 PM, Michael Grant mgr...@modus.bz wrote: Thanks. Other than the 1 extra byte thing... if I'm using MyISAM and assumming I have a string that's 150 characters is there any advantage to using varchar(150) over say TEXT or any of the other text type fields? that's

Re: mySQL data types - possible db bloat with text type? yes or no?

2010-09-03 Thread Michael Grant
thank you sir. On Fri, Sep 3, 2010 at 12:34 PM, Won Lee won...@gmail.com wrote: On Fri, Sep 3, 2010 at 12:23 PM, Michael Grant mgr...@modus.bz wrote: Thanks. Other than the 1 extra byte thing... if I'm using MyISAM and assumming I have a string that's 150 characters is there any

mySQL data types - possible db bloat with text type? yes or no?

2010-09-02 Thread Michael Grant
Normally I use MSSQL but the shop I'm at uses mySQL. I've always built my db's so that the field best matches the data going into it. As an example if I was storing some text data that was max 1000 chars I would use varchar(1000) and not a blob type. I've always thought that this prevented