search - What mysql table structure is better -


I have a search algorithm on my site very complex, so I decided to create a table with the cache or possibly all possible The result I want to ask is that the structure will be better, or maybe not one of them? (MySQL)

  1. Word VARCHAR, Result TEXT or blog where I found the ID of the items (Example 6 for each ID Character)

  2. word VARCHAR, results INT, but words are no longer unique

I think I have 1 to 200 000 rows I have 1000-10000 ids in each row or 200 000 000+ rows 2)

takes more than ever storage memory But I think that 200 mln is non-unique in lines 1 It will be very fast to find 1 unique row between 200 000 and 000 lines.

I think about the index on the word column and no sphinx.

So what do you think?

ps, sorry for my english as always, if it is not very good.

MySam looks the default table. I see the use of most people, and I never had a situation where MyISAM did not work well and if you want to separate something then both the list of benefits of each table type available in MySQL.


Comments

Post a Comment