Slow access to web pages

[Chris Hopkinson]

I have a new server setup (Windows 2003) with FileMaker Server 7 Advanced. As far as I can tell everything has installed correctly following the instructions. However, when I try to access a database using web publishing the response is painfully slow .. it takes a few seconds to refresh each page. This is occuring with several different databases .. some of which are very basic.

I don't have the same problem with I use File Maker Developer 7 to access the files from a remote workstation .. everything is good. I also don't have any problems with speed when I share the same files using Developer 7 from a workstation .. I can use IE to connect with no problems.

The problem only occurs when I use IE to connect to FileMaker 7 Server Advanced. I have tried rebuilding the server from scratch and reinstalling File Maker Server 7, with no success.

Any ideas??

[email protected]

[Martin Brändle]

Do you use Instant or Custom Web Publishing?

[Ivan Tan]

Try adding your server in the Internet explorer options -> Proxy exceptions.

Bypass the server, maybe your proxy server causing slow connections.

Another possibility is Network problems. Make sure line is clean, switch is 100 baseT and have on the same subnet, network area not router to forward package.

if it's remote server slowness is due to your WAN.

[AnFrusch@pepp]

Try adding your server in the Internet explorer options -> Proxy exceptions.

Bypass the server, maybe your proxy server causing slow connections.

Another possibility is Network problems. Make sure line is clean, switch is 100 baseT and have on the same subnet, network area not router to forward package.

if it's remote server slowness is due to your WAN.

I experienced the same situation.

How do I solved it? I rewrite my database using only the necessary fields and informations (no calculated fields, all the calculations are made by the xslt/Xpath stylesheets), I increase the cache size to medium using the FMSA web management (the consolle at localhost(or host name)/fmi/config) and creating many layout containing only the required informations for some specific query/page (as you can do with a SQL 'SELECT field, field FROM' table statement).

the XML source will be optimized in this way and your FM server will work faster.

This is not a browser bug/problem to me

[Chris Hopkinson]

Thanks for your suggestions .. I have done some more testing and I can now give a little more information ..

The problem is definitely not caused by the proxy or by network problems. I have now set up two machines running on one 100M switch. One is running FileMaker sever 7 advanced on Windows 2003 server. The other is running File Maker 7 Developer on Windows XP. There is no proxy or firewalls turned on.

I have setup the same set of files on both machines. The server is sharing the files using File Maker server advanced web publishing. The XP machine is sharing the files using Instant web publishing.

When I use a third machine to connect to these machines the files shared off the XP machine (using IWP) work very well with no problems. When I connect to the same set of files on the server (Using FM Advnaced Web publishing) I get very slow response from the files (it take 3-4 seconds to refresh a web page).

When I connect to either machine using another copy of FileMaker and Open Remote I have no problems with speed issues.

The problem is definitely isolated to the Web Publishing on the server - something is causing this to run at a very slow speed. I can't see anything in the options that looks promising to rectify this. As I said in the first post, I have already rebuilt this machine once, and the server is not showing any other problems and it is not running any other programs.

I realise that I could just use IWP to share these instead of the server .. but I brought the server version to allow more access to these files!

Any further suggestions would be appreciated as I don't know what else to try from here.