engine settings

[delphidestructor]

Does anyone know of any pervasive engine (O.S. Novell Netware 5.1) settings that may need to be changed to increase performance? We have an in-house app that uses pervasive 2000i sp4 (transactional only) but we have just added the accounting package ACCPAC that, I’m assuming, is using relational access and now when there are over 2 users connected in the accounting package, all apps come to a stand still. Thanks in advance for any help.

Mike

 

[TomKane]

You might look at pervasive monitor - (this is on v7 might have a different name in you version) - you can use it to see if any settings such as number of open files have reached the maximum setting. It's funny but we find things to work the other way around the transactional settings take priority over the relational.

 

[noodles1]

Pervasive Cache Setting has a significant influence on performance. It is recommended by Pervasive that the Cache setting be between 25-40% of server memory for optimum performance. Also, there is no performance benefit from having a Cache size that is greater than the total DB size.

For the servicing of remote users, Communications Threads plays a role as well. For up to 32 users, 1 Comms Thread per user is OK. Beyond this, it becomes a burden on the O/S to manage a greater number of threads. LIberal use of the Pervasive Monitor during tuning and testing revised settings is crucial to determine when settings are reaching their Peak, giving you an indication that these settings require revision.

Having a requisite number of Background I/O threads is alos crucial. This value is very dependent on your application's behaviour. The recommendation is 1 I/O thread per 8 files opened simultaneously.