Open Remote very slow

[Doubledunk]

Hello community, I have a question that I hope you can help me with. I currently have filemaker server advanced on a Mac Xserve 10.4.11 and filemaker server advanced being 9.0v3. my clients are also 9.0v3. I have this file that has pictures embedded in it, it is composed of 7 layouts (3 layouts which use the same container field to store a 40 kb picture, and 4 other layouts that have 16 text fields in each of them) The pictures are embedded within the file, to make it a final size of 329.2 mb

My question is, when I try to remotely open this file, it takes about 1 minute before it can actually show the first layout. What is worse is that after it loads for every other record i browse it takes 10 seconds to jump to the next record. Why is it so slow? 329 mb should not be too hard for filemaker to host on 1 file. oh and this is hosted on a gigabit lan.

Any suggestions? Thank you in Advance

Carlos C.

[Steven H. Blackwell]

There are so many things to check here outside the architecture of the file itself.

Installed RAM on the server

Server cache

Number of files and guests set to be hosted or allowed in the console

Drive configuration

Type NIC card

Type drives in server

network typology

bad cables, switches, etc.

Workstation configuration, especially workstation cache and free space on hard drive

etc. etc.

Steven

[Doubledunk]

Thank you for replying to my post. I will try to check these things. However, I am a bit confused as to what workstation cache you are talking about. Is there an option on filemaker client where you can increase the amount of cache?

Thank you for your time and patience

Carlos C.

[Steven H. Blackwell]

Is there an option on filemaker client where you can increase the amount of cache?

Yes, in the preferences. Also, be sure there is at least 1 GB free disk space on the hard drive of the workstations.

Steven

[Doubledunk]

Installed RAM on the server

Server cache

Number of files and guests set to be hosted or allowed in the console

Drive configuration

Type NIC card

Type drives in server

network typology

bad cables, switches, etc.

Workstation configuration, especially workstation cache and free space on hard drive

Ram on server=1 GB

Number of files set to be hosted=50

Guests=250

(I am currently hosting 11 files with 10 clients tops)

Server Cache=240mb

Drive configuration=Mac OSX Extended Format

NIC=Gigabit

Bad Cables/switches=negative

Workstations free space/cache = more than 1GB/240MB cache

I discovered that if you open the databases using iwp it works great. However, if I try the client it is very slow.

Any other ideas?

Thanks Carlos C.

Edited February 13, 2008 by Guest

[Steven H. Blackwell]

1 GB is not enough RAM for Server. 2 GB minimum.

Turn down the client and file settings to about 10% over what is needed.

Workstation FMP cache--12 MB.

Steven

[Steven H. Blackwell]

Drive configuration refers to the type drive. Sorry for the imprecision of the question.

Steven

[Doubledunk]

I will be upgrading the ram on the Xserve to 2GB to see if it improves performance. Thank you for all your help.

Take care CC

[xochi]

I have a 2gig+ database served on gigabit LAN and it opens in a second or two tops.

My guess is that you have a dangling file reference that points to nowhere. Go to File/Manage External Data Sources (has a different name in FM8) and make sure your file references are pointing to the right place? Are you using the WAN IP or LAN IP, etc.?

Also : re client-side caches, I'm a big fan of 64MB or larger caches on a fast LAN.