DataEase & Lantastic

                      A Winning Combination

	Presented for the First International DataEase Users Convention
			May 11 - 13, 1992
			    Boston, MA




                          Phil Winkler
                      PLM Consulting, Inc.
                  DataEase Certified Consultant
                       911 Washington St.
                      Wilmington, DE 19801
                          302.984.2698
			CIS: 72426,1153
                Features, Advantages & Benefits

Features:

     1. Runs on DOS
     2. Low RAM requirements, can be loaded High
     3. Includes cache, Mail, Pop-up manager
     4. Printer spooling
     5. Quick installation
     6. Full network security
     7. Access by User or Group
     8. Audit trails
     9. NETBIOS compatility; familiar NETBIOS commands
     10. Readable manuals

Advantages:

     1. Two manuals, instead of many
     2. User installable; fast default install
     3. No special formatting
     4. Familiar operating system operation
     5. Low cost per workstation
     6. Wide user base
     7. Compuserve support, telephone support

Benefits:

     1. Works well with DataEase
     2. Low maintenance
     3. Ethernet system upwardly compatible with Novell
     4. One day or less install, configuration and training
     5. Peer to peer operation
     6. Works with all softwareHardware Requirements
Recommended for optimum performance:

     1. Dedicated 386 server with => 4 mb RAM, 18 ms disk
     2. 386SX workstation with => 2 mb RAM, 18 ms disk
     3. Ethernet topology
     4. DOS 3.3 or 5.0 (highly recommended)


                          Configuration

A: Server

     1. CONFIG.SYS

          FILES=255
          LASTDRIVE=Z
          BUFFERS=30
          FCBS=16,8
          SHARE /F:2048 /L:1000

B. Workstation

     1. CONFIG.SYS

          FILES=60       (or higher, depending on application)
          BUFFERS=30     (or lower, depending on cache)
     
     2. AUTOEXEC.BAT

          SET DENAME=    [unique name]
          SET DEPATH=    [network path where DENETWRK.OVL and
                         PRINTERS.DAT files are located.
          CALL LOGIN.BAT

C. DataEase

     1.   Select OTHER as network type. Turn off conflicting user
          messages.

     2.   Start DataEase with DEASE -M or DE16M -M (enables
          multi-user file and record locking features
          (undocumented in versions <= 4.24)

     3.   DataEase Database configuration (page 5)

          (1.) Shared
          (2.) None
          (3.) Shared
          (4.) Lock files
          (5.) Lock nothing
                     DataEase Optimization

1.   Ensure every form has ONE unique field (concatentate using
     JOINTEXT, if necessary), make it indexed and the first
     indexed field in the form. Ideally, it should be the FIRST
     field in the form. Index the link field in related forms.

2.   Eliminate, as much as possible, virtual fields with SUM OF,
     COUNT OF, HIGHEST OF, LOWEST OF in the derivation formulas.

3.   Ensure relationships have only ONE match field.

4.   DQL WITH statements including multiple ANDed criteria should
     have the MOST selective field listed first; indexes on other
     ANDed fields in the WITH statement can decrease performance
     dramatically.

5.   Ensure your forms are in 3rd Normal Form (3NF).

6.   In system workstation configuration (page 1), set the
     default sort disk to a local hard disk [eg: c:\temp].

7.   Use Jada Tools to periodically reorganize your system files.

8.   Have users log out when not using the application

9.   Instruct users to F10 into all the forms they will be
     routinely using when they first login to DataEase. 

10.  Join a DataEase User Group in your area or subscribe to the
     TDUG Newsletter.