Re: DBspace size

On Tue, 01 Sep 1998 00:48:02 GMT, mjgator@sibretown.com wrote: >Is there a good rule of thumb to use when setting up a new database (NT)..for >how much room to allocate for the DBspace? Yes. 2 GB per chunk. Mostly 1 dbspace = 1 chunk but you may want larger dbspaces (more chunks) if you have single tables that are larger than there is space for in one chunk (the alternative which is often very usefull is fragmentation - 1 table fragmented over many dbspaces). If you think you can get away with smaller chuncks think about the price of disk drives these days. Of course if this where for the Personal Edition you would probably allocate smaller chunks if you had less data, but not for a larger installation. Do you want to know how much space your tables and indexes will take up? There are formulas in the manuals, but we have allways found it easier to simply load a significant amount of data and see the results. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)