is it better to store keywords in a table like this: table --------------------- keyword | url | count| Code (markup): or like this: -------------- all words | url Code (markup): the first way seems to be considerably faster, but would take up a lot more space. the second way seems to be much slower but take much less space. how do search engines index the pages? by word or by page? or do they do something totally different? how would you suggest to store the keywords?