the_new_guy — 2011-05-10T13:55:47-04:00 — #1
So, I will be have over 1 million small text entries. Think twitter size. Each entry will have a variable mount of metadata. I am going to implement search on the entries and it's variable metadata. Should I store the metadata in the text field and do some string magic in the server side code to split it up? Or, should I implement a many to many like tag system for the metadata of the entries?
webcosmo — 2011-05-10T14:35:47-04:00 — #2
i would prefer the tagging option, since search would be lot easier to handle.
r937 — 2011-05-10T14:58:59-04:00 — #3
server side "string magic" is fine, as long as you are happy with doing a table scan of the entire table every time you want to search for something
wwb_99 — 2011-05-10T15:34:17-04:00 — #4
I'd skip the RDBMS and use something like lucene to handle the tag (and full-text) search duties.