[PHP] RE: Image library

2002-08-21 Thread Philip Hallstrom
> [snip] > > Having a large number of files in a single directory does affect > performance, > > the degree of which depends on the filesystem. > > This is generally accepted wisdom for dealing with large numbers of files - > but what number is considered "large"? > Any rules of thumb, for differe

[PHP] Re: Image library

2002-08-21 Thread Philip Hallstrom
Lots of good ideas. One other thing to consider when designing this is the possibility of multiple web server accessing a single database server. If you use the file system method which assumes that the web/db are on the same server as soon as you want to have multiple web servers you'll run int

[PHP] Re: Image library

2002-08-21 Thread Bogdan Stancescu
The answer I would give at this moment would be a variant of your A) version where the hash directories would further contain directories limited to, say 300 images. Found it out after a painfully slow experience with MySQL blobs. I did not however implement this solution yet (still using the