At 07:22 PM 6/24/99 , Benjamin Pflugmann wrote:
>20MB key buffers do not fit the requirements of your indexes.
Thanks for explaining this. I think i finally understand.
>If you have a lot of common URLs (e.g. one website I handle has only
>about 50 different URLs, the rest is done with parameters to CGIs),
>then I strongly second the suggestion of Daniel and you should
>normalize your table, so you would only have an id for your URLs which
>would result in an index size of only about 1MB for your table (and
>also reduce the size of your database).
You'd think I'd remember all these things since I used to work for Oracle,
but I guess you'd be wrong.
Anyway, I've normalized the data as you suggested and it looks like it is
definitely the right way to handle this. Thanks for all your advice and
suggestions!
Jon Drukman
Director Of Technology
GameSpot
