Subject | Sizing the Server |
---|---|
Author | Paul Schmidt |
Post date | 2001-12-31T13:20:19Z |
Hello List:
I trust everyone had a good Christmas, and is prepared for Y2002,
man 2002 already, time flies...
Does anyone have detailed info on sizing a server for FB? For
example for so many connections you should have so much ram
available, etc. How about disk space, if I have a table with the
following structure:
CREATE TABLEX (
TABLE_ID INTEGER,
NAME VARCHAR(50),
AMOUNT DOUBLE PRECISION DEFAULT 0.0 NOT NULL,
CONSTRAINT TABLEX_PK PRIMARY KEY (TABLE_ID));
Is there any way to determine roughly how much 50,000 records
will take up, how about 500,000 or 10,000,000 will take up on disk?
Ball park is okay, within 10% say? How about indexes and the
like?
Thanks
Paul
Paul Schmidt
Tricat Technologies
paul@...
www.tricattechnologies.com
I trust everyone had a good Christmas, and is prepared for Y2002,
man 2002 already, time flies...
Does anyone have detailed info on sizing a server for FB? For
example for so many connections you should have so much ram
available, etc. How about disk space, if I have a table with the
following structure:
CREATE TABLEX (
TABLE_ID INTEGER,
NAME VARCHAR(50),
AMOUNT DOUBLE PRECISION DEFAULT 0.0 NOT NULL,
CONSTRAINT TABLEX_PK PRIMARY KEY (TABLE_ID));
Is there any way to determine roughly how much 50,000 records
will take up, how about 500,000 or 10,000,000 will take up on disk?
Ball park is okay, within 10% say? How about indexes and the
like?
Thanks
Paul
Paul Schmidt
Tricat Technologies
paul@...
www.tricattechnologies.com