I am working on a project where I have to store and retrieve huge amounts of multimedia data (JPEGs, AVIs etc). Is MySQL a good choice for it? What are the performance and scalability trade-offs?

Would it be easier if I use personal Oracle with InterMEDIA?

Thanks!

My advice would be to store the multimedia files in a file system, and store a URL or something like it in your database. File systems handle files well, databases handle tables well... I don't know of a "one size fits all" solution.

-PatP