Right, and it is storing more then I need. After
running it a few times, I decided to see what happens
if someone chose every parameter possible. What I
found is that even if I just saved the keywords, I'd
still need to use mediumtext. In mysql, there doesn't
seem to be anything between varchar or tinytext and
medium. Which from a naming convention makes sense.
>From the specifics (tinytext - 255 chars, mediumtext -
16,000)is a big hit to upgrade too just for maybe at
maxium 500 characters (I didn't count)
I just mention this since I think tablespace is
increased when using mediumtext. So maybe, after
everything is factored it's not going to be a huge
difference in storage. ?
--- Joseph Crawford <[EMAIL PROTECTED]> wrote:
> Not so much that it is bad but you might be storing
> data you dont need
> to, all you really need to store are the keywords
> the person has
> searched for.
> Joseph Crawford Jr.
> Codebowl Solutions
> [EMAIL PROTECTED]
> For a GMail account
> contact me OFF-LIST
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php