This forum is Read Only . If you feel a thread should be added to the FAQ please contact a moderator


Postby achimbelau » Thu Mar 07, 2013 3:25 pm

we are facing quite a lot problems concerning speed in the network. We are working on a server

Operating system: windows server 2008 R2 Standard 64bit
System model: hp proliant ML150 G6
8gb memory
750 hdd

all workstations are Win7/32

ffenics network options are

strategy: full
record entry locking: none
while processing: lock records
while selecting: nothing
shared locks when list only : yes

are there any parameters we can change in order to improve performance ??
Achim Belau
Posts: 230
Joined: Wed Dec 31, 2008 2:10 pm
Has thanked: 0 time
Been thanked: 0 time

Re: network

Postby Phil Winkler » Thu Mar 07, 2013 4:14 pm

Probably the biggest thing you could do is to ensure your anti-virus software on the server and all work stations has the data folder excluded from being scanned.
Phil Winkler
PLM Consulting, Inc.
Phil Winkler
Posts: 889
Joined: Fri Sep 07, 2007 12:45 pm
Has thanked: 0 time
Been thanked: 0 time

Re: network

Postby Pete Tabord » Fri Mar 08, 2013 11:16 am

And also

a) make sure every workstation has a local temporary directory set for Ffenics.

b) Don't have SQL server or MS Exchange Server on the same box as your database. A small server dedicated to FF (but with proper RAID disks) will work much better than some megabox doing a dozen different things.

The bottlenecks are network traffic and disk access time. CPU power on the server is almost irrelevant, as is memory size. The reason for not wanting SQL etc is that they do maintenance at unpredictable times and create disk access bottlenecks. Local temporary directories reduce both server disk access and network traffic. AV slows down disk access because they typically (and stupidly) virus check every write operation even though these are not executable files. Proper (hardware) RAID speeds up disk access if you have multiple mirrored drives.

For all these reasons possibly the worst thing to use as an FF server is an MS SBS machine with everything activated.

Oh, and turn off shared locks when list records, unless it is absolutely vital in you environment to have records locked while you run a report that doesn't modify data. I can't think why it would be, since you have 'lock while selecting' set to none.
Peter J. Tabord
Head of Development
Database Software Ltd.
Pete Tabord
Posts: 1880
Joined: Fri Sep 07, 2007 12:48 pm
Location: Caernarfon, Gwynedd, UK
Has thanked: 0 time
Been thanked: 3 times

Return to Ffenics FAQ

Who is online

Users browsing this forum: No registered users and 1 guest