INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Improve Pervasive Performance

Improve Pervasive Performance

(OP)
I am currently working with a client that is running a DOS based application that uses Pervasive SQL 2000i. I was brought in to handle some performance issues. After obersving the application for a few minutes I realized that they needed tamedos to handle the keyboard inputs in Windows XP. Next step was to check out the AV exclusions. That was an issue also. I excluded all of the vital database components on the servers and workstations. After a couple of hours the usability of their program was tremendously improved.

I have noticed that their day to day reports take a long time to complete. I asked the office mangager to run a typical report while I observered the task manager on the server. The Pervaisve server process never went above 3-4%. Is there anyway we can boost performance during these reports? I have talked with serveral people and we have concluded-

1. Remove the unused protocols from Pervasive
2. I noticed that the person who setup the network built a backbone network between the two servers in their network. I have heard that Pervasive gets bogged down when there are two network adapters in the server it is loaded on. I think that this design with the backbone network is poor anyway so I will be removing it. It has already caused some major Active Directory name resolution issues because the Adapter in the backbone network keeps publishing itself in DNS.
3. Increase the cache size.

Is there anything else that I can do to improve the speed of these reports?

Thanks

STF

RE: Improve Pervasive Performance

A couple of questions and a couple of comments:
1. Removing the unused protocols is a good idea.  
2. Pervasive doesn't have any bogging problems with multiple NICs.  What can cause problems is when Pervasive listens on the "wrong" NIC.  
3. Cache can help in some cases, especially if the same data is read repeatedly.
Questions:
1. What requester are the DOS apps using (BREQTCP, BREQUEST, BREQNT, BTRBOX)?  
2. What interface do the reports use (are they DOS based also or do they use Windows and possibly ODBC)?  


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: Improve Pervasive Performance

(OP)
I am not sure how to determine which requester that they are using. Can you clue me in on how to do this? Could this be a problem?

The reports run in the same dos window as the program.

RE: Improve Pervasive Performance

Is the DOS app started by a Batch file? If so, post it.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: Improve Pervasive Performance

(OP)
@ECHO OFF
REM BREQUEST
MDS /nol

RE: Improve Pervasive Performance

Looks like you are using BTRBOX (since BREQUEST has been REMmed out).  Are you connecting using TCP/IP or SPX?  Check the monitor for the active users and it'll give the network address as either a TCP/IP or SPX address.  You can also look in "Communications" under the "Microkernel".

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: Improve Pervasive Performance

(OP)
TCP/IP is the protocol of choice. Nothing else is enabled. I checked the monitor and all of the users are connecting via tcp/ip.

RE: Improve Pervasive Performance

The BOOTH protocol may be able to assist you as well.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close