MySQL Forums
Forum List  »  Optimizer & Parser

Re: Great masses of files on database.
Posted by: Anthony Willard
Date: May 26, 2006 01:37PM

You have a common question and this topic is covered many times, here and elsewhere on the web.

The simple problem is 1) store the information in the database or 2) store metadata in the database and the files elsewhere.

It may be easier to store the metadata (patient links, path to file, etc) in the database and store the files on a redundant data storage area.

You could do a similar approach using the database as the media store, but it still uses the database resources.

Storing such large data files within the database would add significant bloat to your backup and managment processes.

HTH.

Options: ReplyQuote


Subject
Views
Written By
Posted
2555
May 26, 2006 01:06PM
Re: Great masses of files on database.
1940
May 26, 2006 01:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.