Btrieve application slow on win XP


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.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mirtheilSoftware DeveloperCommented:
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.  

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wkoelewyAuthor Commented:
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...

mirtheilSoftware DeveloperCommented:
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).
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.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.