home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Black Box 4
/
BlackBox.cdr
/
lan
/
lantip.arj
/
LANTIPS.TXT
Wrap
Text File
|
1992-05-28
|
4KB
|
133 lines
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 softwareHardware 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.