well,
I can answer a few of these at least...

On Monday 02 December 2002 10:18 am, you wrote:
> I have a customer that is currently using a shopping
> cart which utilizes the file system as a database.
> He has one directory which contains thousands of
> small files (one per customer).
>
> In an effort to persuade him to move the system to
> a SQL server, can anyone offer me some numbers as to
> the limits on files in a directory?
>
> Are these OS dependent, or more specifically filesystem
> dependent?
>
> For instance, are there differant values for:
>
> msdos
file limits: 255 dir entries and max disk size of 500 MB (fat 16 old model)

> fat32
supports up to a 50 GB drive in single partition mode. max file size < 2gb. 
unknown on max dir entries.

> ntfs
very inefficient for small files (under 64 k) as cluster sizes are large (64 
kbytes/cluster). unknown on max disk size supported or max dir entries.

> ext2
2 gb max file size, unknown of number of dir entries or max disk size.
> ext3
still finding out

> reiserfs

well, thats some of what I know.

Technomage

--- 
I will not be pushed, filed, stamped, indexed, briefed, debriefed, or 
numbered!
My life is my own - No. 6