Btrieve application slow on win XP

Posted on 2003-11-22
Last Modified: 2013-12-25

A friend of mine has a very disturbing problem with an application which uses Btrieve. The problem is that the performance of the application is not was it used to be. The application was running under NT4 with the clients running on W98. Now we installed XP and the application slows down as soon as more then 1 person is using the application. The screens open slower and closing screens is even slower(it takes 5 sec.!!). When running in the "old" environment, this was no issue at all and the application was performant enough. The vendor of the application has a very good solution for us: Install Persuasive Btrieve Client/Server and everything is fine. I'm not interested in a solution like this, because it is not clear to me why it worked well when running on NT4/W98 and why isn't it working that well using XP? We never had a need for the client/server software as we were told it runs fine using a peer-to-peer configuration with sharing the applications install directory on the "server".
Does anybody know what the solution is and do we really need to use the client/server software?
Thanks in advance.

Question by:wkoelewy
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 18

Accepted Solution

mirtheil earned 25 total points
ID: 9804522
HOw many users are going to evenutally be using the application?  If it's above 5, I would suggest the client/server engine.  Also, what version of Btrieve are you using? If it's Btrieve 6.15, I would strongly suggest upgrading to at least Pervasive.SQL V8 Workgroup, then if you've got more than 5 users, upgrade to the Client/Server version.
Why is the application slower on XP, I can't say withough at least knowing what version of Btrieve you're using.  

Author Comment

ID: 9805777
There are 4 users at this moment and the version of Btrieve is version 6.15 (as you already guessed). Why the application is slower on XP puzzles me as well.... I now need to find out the best place to buy and the effort we need to install Pervasive SQL. Thanks for the time to write me an answer...

LVL 18

Expert Comment

ID: 9805838
YOu can buy Pervasive from their web site ( or from resellers like Provantage (  The effort shouldn't be too great, it should simply be a matter of installing the newer engine and clients (if you go Client/Server).

Expert Comment

ID: 10056998
Our company had the same slow down results, but previosly we already had several workstations running XP. The slow down was caused by files being upgraded from btrieve 5.1 format to 6.15 format. Our app uses about 12 files, some are still in 5.1 format. It was interesting to watch the app close each of the files, only pausing (about 3-5 secs.) on the files that had already been converted to the new 6.15 format. The 5.1 format files closed instantly. We were using 9 workstations, a mixture of 95/98/XP. Fortunately for us, our app only closes all the files upon exiting.

Your slow down is caused from the btrieve Close command. Yes, upgrading to Client/Server Btrieve would solve the problem ($$$), but two other workarounds may do you well. If you spent the money to upgrade to Client/Server Btrieve, then the server would be responsible for closing files and the client is freed immediately from the closing task. But two other workarounds might buy you some more time:

1) Have the application tweaked so that it does not constantly open and close any multiuser btrieve files (temporary single user files are ok). Ideally the app should open all files on startup, then close all files upon exit. If you can't modify the app, or the software vendor won't do it then consider this next approach.

 2) Determine which files are the culprits, which files are constantly opened and closed. Then convert those files to the btrieve 5.1 format. Do a bclone and a bcopy or use Btrieve File Manager. Btrieve 6.15 will happily manage and deal with your 5.1 formatted files. As long as the application doesn't require some of the new features in the 6.15 engine which might require the file to be in a 6.15 format you should be fine. You might check with you software developer to verify this won't be a problem. If they are unsure, then just try it. Of course make backups and setup a test away from your live data to protect your data investment.


Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question