dbTalk Databases Forums  

Control Center configuration with Btrieve files in a very very slownetwork

comp.databases.btrieve comp.databases.btrieve


Discuss Control Center configuration with Btrieve files in a very very slownetwork in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Axel Potthoff
 
Posts: n/a

Default Control Center configuration with Btrieve files in a very very slownetwork - 12-22-2010 , 03:16 PM






Hi,

a customers btrieve files are located at a very very slow network.

Normally the files are closed.
Every few minutes the application does an "insert record" or retrieves
some keys from another btrieve file. After selecting the key, the
corresponding record has to be read.

There is no concurrent access to the btrieve files when the problem occurrs.

The problem is, that due to slow network, the application (running under
Windows XP pro) mostly gets btrieve status "invalid file name".

There is no server engine. The application works with a workgroup
engine. This works very well at all other customers.

My question:
Can ther something be tuned at the Control Center?

Thanks

Axel

Reply With Quote
  #2  
Old   
BtrieveBill
 
Posts: n/a

Default Re: Control Center configuration with Btrieve files in a very veryslow network - 12-23-2010 , 05:22 PM






Are you using the old Btrieve 6.x engine? One of the newer
Pervasive.SQL engines? Something else?

I ask because the Btrieve 6.x engine supported use from multiple users
using a shared-file design, but all newer engines (including those that
come with the Pervasive Control Center) do not -- they can provide
access from ONE engine at a time.

If you have Pervasive.SQL 2000i or newer, then you should install an
additional license on the database server (the machine which physically
contains the files) and configure it as the permanent gateway.
Information on using the Gateway Locator can be found in the manuals or
here:
http://www.goldstarsoftware.com/press.asp
With a single machine storing the files AND hosting the engine,
performance is best.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive Training - March 2011 in Chicago ***
Happy Holidays from Goldstar Software Inc.
http://xkcd.com/835/


On 12/22/2010 3:16 PM, Axel Potthoff wrote:
Quote:
Hi,

a customers btrieve files are located at a very very slow network.

Normally the files are closed.
Every few minutes the application does an "insert record" or retrieves
some keys from another btrieve file. After selecting the key, the
corresponding record has to be read.

There is no concurrent access to the btrieve files when the problem occurrs.

The problem is, that due to slow network, the application (running under
Windows XP pro) mostly gets btrieve status "invalid file name".

There is no server engine. The application works with a workgroup
engine. This works very well at all other customers.

My question:
Can ther something be tuned at the Control Center?

Thanks

Axel

Reply With Quote
  #3  
Old   
Axel Potthoff
 
Posts: n/a

Default Re: Control Center configuration with Btrieve files in a very veryslow network - 12-24-2010 , 04:50 AM



Hi Bill,

On 24.12.2010 00:22, BtrieveBill wrote:
Quote:
Are you using the old Btrieve 6.x engine? One of the newer
Pervasive.SQL engines?
P.SQL 11.0

Quote:
Something else?
No.

Quote:
I ask because the Btrieve 6.x engine supported use from multiple users
using a shared-file design, but all newer engines (including those that
come with the Pervasive Control Center) do not -- they can provide
access from ONE engine at a time.
As I wrote before:
Quote:
On 12/22/2010 3:16 PM, Axel Potthoff wrote:
There is no concurrent access to the btrieve files when the problem
occurrs.
And I have found at other customers with many (up to 30) workgroup
engines running concurrently (but accessing the Btrieve file only every
few minutes) it is no problem.


Quote:
If you have Pervasive.SQL 2000i or newer, then you should install an
additional license on the database server (the machine which
physically contains the files) and configure it as the permanent
gateway.
I will offer this to the customers system administrator. I hope he will
agree.

Thanky you
and
Merry Christmas

Axel

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.