Solved

Btrieve application slow on win XP

Posted on 2003-11-22
4
3,607 Views
Last Modified: 2013-12-25
Hi,

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.

Willem.
0
Comment
Question by:wkoelewy
  • 2
4 Comments
 
LVL 18

Accepted Solution

by:
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.  
0
 

Author Comment

by:wkoelewy
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...

Willem
0
 
LVL 18

Expert Comment

by:mirtheil
ID: 9805838
YOu can buy Pervasive from their web site (www.pervasive.com) or from resellers like Provantage (www.provantage.com).  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).
0
 
LVL 1

Expert Comment

by:hgodfrey
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.

0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Database tuning – How to start and what to tune. This question is frequently asked by many people, both online and offline. There is no hard and fast rule-of-thumb for performance tuning, however, before beginning the tuning process one should a…
APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
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…

758 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now