allbase question

[Michael C. Lee]

Allbase has been in use at my client's site for the longest time. One of my
client's suppliers is Lee of Leetech out in California. Lee and some of his
people were part of the HP project which created Allbase and he is obviously
quite knowledgable. The file declarations in this Allbase database are as
follows:

START DBE 'XXXDBE' MULTI NEW
   BUFFER = (4096, 256),
   TRANSACTION = 128,
   RUN BLOCK = 512,
   CHECKPOINT AUDIT ELEMENTS,
   DATA AUDIT ELEMENTS,
   DBEFILE0 DBEFILE DBEFILE0
      WITH PAGES = 150,
      NAME = 'DBEFILE0',
   LOG DBEFILE DBELOG1
      WITH PAGES = 50000,
      NAME = 'DBELOG1.XXXSDATA.DEV';

CREATE DBEFILESET COMSFILESET1;
REVOKE SECTIONSPACE ON DBEFILESET COMSFILESET1 FROM PUBLIC;
REVOKE TABLESPACE ON DBEFILESET COMSFILESET1 FROM PUBLIC;

CREATE DBEFILE COMSF1
   WITH PAGES = 100,
   NAME = 'COMSF1',
   INCREMENT = 100,
   MAXPAGES = 50000,
   TYPE = MIXED;

ADD DBEFILE COMSF1 TO DBEFILESET COMSFILESET1;


I hope this helps you.


Michael Lee
MCL Systems Inc




jeff@lund.com wrote:

> to all;
> I am working with an application written in cognose
> that uses aLLBASE.  The question relates to the DBEFILE TYPE.
> THere are three, Index, table and Mixed.  I believe that the use
> of mixed could be detrimental to performance, particularly on
> highly used files.  Has anyone had first hand experience
> with
> this to comment?  How about second hand?
> Jeff Kubler
> Jeff Kubler                      |  541-926-3800
> Lund Performance Solutions       |  http://www.lund.com
> Consulting & Training            |
> jeff@lund.com                    |
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.



= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.