I would much appreciate to hear from experienced mySQL practitioners on the following: I have a large relation in mind (strictly fixed length for performance) with potentially 1-3 million entries. Associated with each of these rows i have a variable number of blobs. I would not consider storing them in the table itself for obvious performance and other reasons but i have choices and i would like all your opinions on them : A) Would you store them in a single relation? B) Because of max table size would you consider one table for each possible kind of blob? C) Consider storing them as files in directories? D) If recommending (A/B) which table type is recommended? In particular has anyone experience on the choice between (B) & (C) on performance grounds? e.g. how does directory search compare to an index in mySQL? Regards, Dave. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
