FM slow on a network 
Author Message
 FM slow on a network

We have developed an application for a small department of a large
bureauracy. They are running FM5 on a PC. The main database file has about
15000 records and is about 20mb in size. There are six other files but these
remain fairly small or get minimal access.
When the database is running on a standalone machine it is lightning fast.
However the main user needs to let her clerical assistant share the database
with her from time to time. For this reason the dbase needs to live on the
office NT network. There is only ever a maximum of two users and mostly only
one.
The network is fairly big, covering several floors of a large office
building and when the file is open it runs incredibly slowly. Sometimes
there is even a perceptible delay between pressing a key when entering data
in a field and seeing the letter appear on the screen. Calculations etc are
so slow that the database becomes almost unusable. All of this is true even
if only one user has the files open.
I appreciate the problem is with the network rather than FM but we have no
control over the network at all and the techs who run it are rather anti-FM
and don't want to help. When a user is using Word, for example, the slow
network isn't evident so they insist it's not their problem.
My question is does anyone have any bright ideas about we can maximise
performance over the network when there are only one or two users?
Thanks
Greg


Mon, 10 Nov 2003 21:44:09 GMT
 FM slow on a network

Sounds as though you are not using Hosts to open the files, but are using
the network to host them. Try the groups's FAQ at:
http://heifer.ucc.usyd.edu.au/cdf_faq/ for further information.

--

John Weinshel
Datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634


Quote:
> We have developed an application for a small department of a large
> bureauracy. They are running FM5 on a PC. The main database file has about
> 15000 records and is about 20mb in size. There are six other files but
these
> remain fairly small or get minimal access.
> When the database is running on a standalone machine it is lightning fast.
> However the main user needs to let her clerical assistant share the
database
> with her from time to time. For this reason the dbase needs to live on the
> office NT network. There is only ever a maximum of two users and mostly
only
> one.
> The network is fairly big, covering several floors of a large office
> building and when the file is open it runs incredibly slowly. Sometimes
> there is even a perceptible delay between pressing a key when entering
data
> in a field and seeing the letter appear on the screen. Calculations etc
are
> so slow that the database becomes almost unusable. All of this is true
even
> if only one user has the files open.
> I appreciate the problem is with the network rather than FM but we have no
> control over the network at all and the techs who run it are rather
anti-FM
> and don't want to help. When a user is using Word, for example, the slow
> network isn't evident so they insist it's not their problem.
> My question is does anyone have any bright ideas about we can maximise
> performance over the network when there are only one or two users?
> Thanks
> Greg



Mon, 10 Nov 2003 22:55:53 GMT
 FM slow on a network

Quote:

> I appreciate the problem is with the network rather than FM but we have no
> control over the network at all and the techs who run it are rather anti-FM
> and don't want to help. When a user is using Word, for example, the slow
> network isn't evident so they insist it's not their problem

I love IT {*filter*}s who think a Word document is equivalent to a database
application. :/  One sits there and accepts a few keystrokes. The other
communicates constantly over the network, sending and receiving
thousands of interactions per minute.

The files should be opened by a copy of Filemaker or Filemaker Server on
the NT server. OS filesharing should be turned OFF, at least to the
folder where the FM files live. All access from guests should go through
"Open -> Hosts" then select the hosted files.

Do not allow remote hosting. Do not allow access through the Network
neighborhood. You should notice immediate improvements in performance
once a proper configuration is achieved. In my experience, a properly
hosted file is only a little bit slower than one on the native machine.

And if the IT {*filter*}s give you trouble, send them to me. I'll pin their
ears back for them. ;)
--
Lynn Allen              Allen & Allen Semiotics
FSA Associate           Filemaker Consulting & Training



Tue, 11 Nov 2003 03:03:46 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Adding windows FM Pro 3/4 to Mac FM Pro 3 network

2. FM Pro slow startup on W2K

3. AppleScript extrem slow and instabil (FM Pro 5.5 / Mac OS 10.1.1)

4. FM Pro slow startup on W2K

5. FM on Web very slow

6. Slow redirection of FM traffic

7. Extremely slow ODBC connection from FM to Excel on a Mac

8. FM Server slow?

9. Web access to FM db gets SLOW...

10. Slow Finds with FM Server 5 NT

11. FM Pro 5 slow with ODBC?

12. Is FM Pro really that slow?


 
Powered by phpBB® Forum Software