I've got a tricky query I hope you guys can help me with.
I have a database of a few millions records, representing subjects from
messages, emails, articles and other sources. We need to perform fast
queries on these to answer clients' requests.
I have created two table related to the search in question:
table_Subject: keeps the subject of the message with a reference number and an
autoinc Id number, like this:
ID: 1, SUBJECT: How to unsintal?, REF: 138
ID: 2, SUBJECT: How to get updates, REF: 4668
table_Words: keeps a numeric hash (crc32 for now) ...