> -----Original Message----- > From: Dan Buettner [mailto:[EMAIL PROTECTED] > Sent: Friday, April 20, 2007 3:16 PM > To: Michael Higgins > Cc: mysql@lists.mysql.com > Subject: Re: advice for blob tables? > > At any rate - based on my experience with the Sybase system I managed, I > would advise you to consider this when designing your database: instead of > having one gigantic table to store every document, try to design a system > that allows for splitting the data across multiple identical tables.
My company offers an archive service for our customers, and we do exactly this. The metadata is stored in a known location, include and index to a table which points to the database/table where the blob is. One such pointer is marked active so it receives all new documents. This allows us to roll over the databases at a certain size, or move them around as needed. Tim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
