Results 1 to 5 of 5
  1. #1
    Join Date
    May 2006
    Posts
    3

    Unanswered: Pervasive 9.1 Server/Client Config

    I do not know if my Pervasive server and clients is cofigured correctly.
    Can someone please let me know how to configure correctly for my
    network...
    1. P4 2.8Mhz Server, 2Gb Memmory, Win 2000 Server, 4x scsi harddrives,
    (All Magic data files is on server) Just a file server!

    2. Magic 3.9 and PSQL 9.1

    3. 50 clients and sometime less on local network.

    4. 10 Terminal Server users running magic on the server.
    (Magic runtime was installed on the server like on an ordenary
    client pc. The remote users then connects with TS and runs magic on
    the server with all having their own ini.)

    Any help or sugestions would be great...
    Thanks
    Last edited by ItMac; 05-25-06 at 07:15.

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Are you having problems? If so, what?
    Why do you feel the Pervasive may not be configured correctly?
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    May 2006
    Posts
    3
    I had a problem where if some clients did transaction on Magic9.3, onley the header of the form is printed, and magic just hangs.
    I then did following on client pc and it worked...
    Under Performance Tuning:
    Enabled > Use Cache Engine
    Disabled > Verify Key Length

    I also want to config Pervasive Server and Client side for following reasons :
    - Get better performance(Close to optimal)
    - To prevent future problems and ceep things running smooth
    - Prevent data and file corruption and problems most i can

    I just want to do as a thorough a job as possable....

    Thanx

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Is this an application you developed? If no, you should contact the vendor of the application for ideal settings.
    For the most part, the settings out of the box are going to meet your three goals. However, settings typically won't prevent data or file corruption with Pervasive. Usually, file corruption is caused by hardware issues (drive going bad, network card corrupting data,etc). Data corruption, where incorrect data is written to the database, is usually caused when an application doesn't validate the data before sending it to the database.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  5. #5
    Join Date
    May 2006
    Posts
    3
    Ok, thanks for the update and crash course.....

    Magic 9.3 is a runtime invironment on witch we run our programs.
    We develop the programs ourselfs with eDeveloper, the development program for Magic 9.3.
    e used to Run Btrieve and Magic 9.3 together, and now we got Pervasive9.1
    to go with magic9.3.

    Can you mabe please comment on the following changes i made in the config of Pervasive9.1?

    Thanks allot..
    Andre

    Server:
    1. Access:
    Accept remote request = on
    Allow cache engin connection = on

    2. Communication protocols:
    Enable auto reconnect = on
    TCP/IP multihomed = on
    TCP/IP port = 1583
    Listen IP adress = 0.0.0.0
    SPXII = off
    3. Data Integrity:
    Operation bundle limit = 65535
    Initiation time limit in msec = 10 000
    Wait Lock Timeout in msec = 15 000
    4. Memory usage:
    System cache = off
    Allocate resources at startup = off
    Back to minimal state if inactive = on
    Sort buffer size in bytes = 0
    Minimal state delay in msec = 300 000
    5. Performance tuning:
    Limit segment size to = 2Gb
    Communication threads = 16
    Cache allocation size in bytes = 429 387 776
    Log buffer size in bytes = 104 8576
    Number of input/output threads = 32
    Max microkernel memory usage = 60
    File groth factor = 15

    Client:
    1. Access:
    Use local microkernel engine = off
    Use remote microkernel engine = on
    2. Communication protocols
    Enable auto reconnect = on
    SPXII = off
    3. Performance tuning
    Use cache engine = on
    Verify key lengthe = off
    4. Application Characteristics:
    Embedded spaces = on
    Verify key length = on

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •