Physical File Layout / Tablespace control

From: AcCeSsDeNiEd <nobody_at_nobody.com>
Date: Tue, 17 Dec 2002 03:52:36 +0800
Message-ID: <9tasvu0to0l8ctl2om59tb5v8e7du0ejqk_at_4ax.com>

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 - 20:52:36 CET

This message: [ Message body ]
Next message: DA Morgan: "Re: Physical File Layout / Tablespace control"
Previous message: Jusung Yang: "Re: Union All & REF CURSOR problem"
Next in thread: DA Morgan: "Re: Physical File Layout / Tablespace control"
Reply: DA Morgan: "Re: Physical File Layout / Tablespace control"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message