Control Center configuration with Btrieve files in a very very slow network

[Axel Potthoff]

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

[BtrieveBill]

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
Bill...@goldstarsoftware.com
http://www.goldstarsoftware.com
*** Pervasive Training - March 2011 in Chicago ***
Happy Holidays from Goldstar Software Inc.
http://xkcd.com/835/

[Axel Potthoff]

Hi Bill,

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

P.SQL 11.0

> Something else?
No.

> 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:

> 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.

> 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