-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Pascal, et al --
...and then Pascal Francq said... % % Hi, Hi! % I have a question. I need to store documents (>100.000) and the word % containing in them. % % They are two way to do the job : [snip] What about a third way? One table for the docs with a docid, one table for all of the words with a wordid, and one table to tie them together containing the docid and the wordid. Duplicate words only require one row in the word table and would have required separate docid entries anyway, so you save. HTH & HAND :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE/Tm43Gb7uCXufRwARAmsQAKDijezqJNt28nKZus1PJxyPZNeixACeNzNx 5DBbgx0Tye/BmxLYTl+TeNU= =PK0V -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]