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

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@goldstarsoftware.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:
> 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

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