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. ? Stuart --- Joseph Crawford <codebowl@xxxxxxxxx> 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 > codebowl@xxxxxxxxx > 802-558-5247 > > 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
