You will probably find a great deal of list members well versed in mysql as it meshes so well with php, so ask away old bean. On 09/04/06, Nicholas Couloute <njcjr@xxxxxxxxx> wrote: > > Yea, okay looks like I am going to be using mysql cause I want an > organized site by genre, author etc. I going to need some resources of > mysql cause I haven't used it before! I have used flatfile for about a > year now! > > On Sun, 9 Apr 2006 12:02 am, Richard Lynch wrote: > > > > > > If the files are constantly changing, scandir is probably as fast as > > it gets... > > > > If you rarely alter the files, do scandir once and store the results > > in, say, MySQL and you can search/sort MUCH faster. > > > > On Sat, April 8, 2006 11:01 am, 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? > >> > >> -- > >> PHP General Mailing List (http://www.php.net/) > >> To unsubscribe, visit: http://www.php.net/unsub.php > >> > >> > > > > > > -- > > Like Music? > > http://l-i-e.com/artists.htm > ~Nick Couloute > co-owner/Web Designer > Sidekick2Music.Com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- http://www.web-buddha.co.uk dynamic web programming from Reigate, Surrey UK look out for e-karma, our new venture, coming soon!
