Physical File Layout / Tablespace control

I will be running a 2Ghz Xeon on Win2k server.

I am intending to store many binary files btw 200kb - 1mb each in a single table.

I am looking at 2000 files per month here. This would amount to about 25gb for one year.

What would be the appropriate tablepsace/size to set for this binary table? Or what if I just left it alone and let it grow into a single tablespace year by year? Would searches and record (binary) retrieval be slow?

How would I make it automatically grow into a another datafile when say a set size limit has been reached for that table \space?

Sorry, I'm not too experienced with tablespaces and the physical file layout.

Thanks Received on Mon Dec 16 2002 - 13:52:36 CST