> Grabbing a half-gig video segment out of any > database I'm sure you're absolutely right about not putting half gig videos in a database!
I was thinking more of an application like an access control system, where there might be tens of thousands of photographs of people, each a jpeg of a small number of K, or a catalogue, again with thousands of tiny photos. The experiment I did with 500,000 operating system files was to see whether smallish blobs (bits of text, in this case, which I didn't need to search or index) were better stored as disk files or in an SQL Server database. The database won hands down on all counts. Tim Ward Brett Ward Limited - www.brettward.co.uk ------------------------------------------------------- On August 5th ip.access will be moving to: CPC1 Telephone: +44 (0) 1223 219000 Capital Park Fax: +44 (0) 1223 219099 Fulbourn Cambridge CB1 5XE United Kingdom ------------------------------------------------------- This e-mail and the information it contains are confidential and may be privileged. If you have received this e-mail in error please notify us immediately. You should not copy it for any purpose, or disclose its contents to any other person. All emails to and from ip.access may be monitored and stored for audit and other legal reasons. ------------------------------------------------------- --------------------------------------------------------------------- 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