A client runs a volunteer program and wants to maintain records for each volunteer. I plan to create a custom volunteer module for this purpose, nothing I haven't done before. But here's the catch. Do to some strange funder regulations they need to keep electronic/scanned versions of every document they collect and they want to store it all on the site and have it so that if you pull up a volunteers record, you can also access the scanned version of the original documents. (there records include everything from brith certificates to criminal background checks to timesheets)

They have 400 volunteers and there's going to be about 30 file attachments for each volunteer, so that's going to be about 12,000 file attachments every year, with 30 files attached to a single node?

Does anyone know if Drupal can handle this? And can I use the built in file attachment feature. I remember hearing once something about not putting more than 1000 files in a single directory, so that might be one problem. But I wonder if there might be others I'm not thinking of.

If anyone can offer some advice I'd appreciate it.

Thanks,
Sam

Comments

StevenSokulski’s picture

Drupal is only limited by the speed of the processors on which your site is running. Drupal can do it. The question is mainly can your hosting company.

styro’s picture

I remember hearing once something about not putting more than 1000 files in a single directory, so that might be one problem.

Generally that will depend on the filesystem (and operating system) you use rather than Drupal itself. I vaguely recall some of the Drupal file handling modules will automatically create multiple subdirectories to make things easier to manage though as well as work around any platform limitations. Best thing to do would be to try them out and read their docs - maybe even contact the module maintainer for advice too.

--
Anton
New to Drupal? | Forum posting tips | Troubleshooting FAQ