My guesstimates are that this database, including indexes, will already amount to 1/2 terrabyte in size. Now if I included that schema for coping with arrays, god knows what size it will reach. With some tables with an estimated 500,000 records, that will then need 1,000,000 records in an array table at least.

Database sizes will fly through the roof, indexing and maintenance times will make the twin xeons look like a 286, and I've got as much chance of approval from the suits than I have of waking up next to Sandra Bullock tomorrow morning.

However, I think it will be using a mix 'n' match of the ideas posted here. For those arrays that do not need searching on, I'm going to stream those into a text field. For those arrays that do need searching on, I'll post those into a table similar to the one that you've just proposed.

Thanks for your help guys.

Edited by - martincross on 07/31/2003 08:25:24 AM