Frank, Friday, February 01, 2002, 2:29:37 PM, you wrote:
FJS> The real design problem is that I'm new to this. However, ... FJS> I'm putting together my own "knowledgebase" using MySQL and built from FJS> various sources including books and list groups of similar form to this FJS> one. It's basically an expanded bibliography. FJS> Different form would have different data elements. A book reference FJS> would include normal bibliography items plus the actual blurb from the FJS> text. FJS> My question relates to source that may be in the form of a file (text, FJS> pdf, etc) and also e-mails. For character based files I could just copy FJS> them into a blob, but I was wondering how large those could be. Instead FJS> of copying the text could you include a link to the file? FJS> What's the best way to handle this? It's a common situation. The best solution depends on your needs, possibilities and expected query traffic to a database. I'd put the link to the file anyway, because it's more efficient then storing a file itself in a database, but I repeat, that's the general advise and that might not be suitable for you. MySQL is fast and efficient, the datasize of blob will suit your needs. FJS> Frank -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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