So say I need 10,000 tables, but I can create tablespaces. Wouldn't that solve the performance problem caused by
Linux's(or ext2/3's) problems with large directories?
For example, if each user creates (say) 10 tables, and I have 1000 users, I could create 100 tablespaces, and assign
groupsof 10 users to each tablespace. This would limit each tablespace to 100 tables, and keep the ext2/3 file-system
directoriesmanageable.
Would this work? Would there be other problems?
Thanks,
Craig