Re: What is best way to do handle audio files?

At 12:01 PM -0400 4/8/06, Nicholas Couloute wrote:

On my website http://www.sidekick2music.com ! I use scandir() [php 5.0] to fetch all the files which are all in subfolders of this one folder. like this: public_html/amrs/$cat/$author/*.amr $cat = different catergoried of music $author = Authors of the particular catergory This way isn't fast when you have over 5,000+ files. I use flatfile for everything on the site! site: http://www.sidekick2music.com Would it run faster if I used mysql? How would this be done? Is there another way when dealing with files and organizing them? CMS?

Nicholas: You certainly can use MySQL to store the url's to the sound files OR the sound files themselves -- MySQL can handle both ways and both ways have their advantages and disadvantages. However, in either event, using MySQL is in my mind a preferable method of organizing a large data set. You'll need to set up a MySQL database, with a table containing the name, catalog, artist, and whatever else you want. Then you'll need to enter the data and finally set up your web site to dynamically access the dB and pull out what the user wants. I've done this with several sites, but I charge. However, it's certainly something that you can receive free help from this list. tedd -- -------------------------------------------------------------------------------- http://sperling.com