Sorry forgot to update this one.

We still don't have the full spec as such, but...

We all got excited over the BLOBS way too much.

We are actually talking word documents and the such, so currently they average 50k in size.

They built in a huge amount of overhead on space requirements. The data will only live in the db for a year. The supplier took current values, multiplied by three (just in case we needed a backup and backup of that) and 1/3 extra space.

Throughput is managable. Seem to remember in the region of <5 transactions a second.

And now the project has gone quiet. So waiting here back when the hardware is purchased etc.

Thanks Abel & Gail. It's certainly given me a chance to refresh my memory on Filestream, even though it's not needed here!

Rodders...