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