Read this article for it's design on database storage.. I have several big implementations on this design which are fast, reliable and scalable (one of them in the medical field aswell)
http://php.dreamwerx.net/forums/viewtopic.php?t=6 On Sun, 1 Feb 2004, Yuri Oleynikov wrote: > Hi everyone, > I am new to MySQL. I am starting a database project for a medium-sized > medical office. I chose MS-Access (on 10-terminal pre-existing Win2K > intranet) for rapid front-end dev and familiarity to the existing users. > I plan to use MySQL on Linux server for backend for its speed, great > support and ease of use. > The database will consist of doctor's reports, schematic drawings and > photos (500K JPGs and 50K PICTs). I am planning to implement that with > BLOB or, alternatively, with file system while storing links to files. > Later we may add webaccess through MySQL webserving or by using Access > webserving options. > Has anybody done anything similar? What is the best way to implement > image storage (and, in future, movies, maybe)? > Thanks a lot. > yuri. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
