Filemaker php extremely slow

[kiwiora]

We are experencing very slow response from filemaker/php. Has anyone else had the same problem? We are running a relatively simple database as the only thing on a server. It is for a catalogue that is viewed on the company's intranet.

When it crashes it strings up a whole stack of connections from IIS to filemaker server which are never cleared.

Filemaker Server 9 Advanced, all updates installed. PHP 5.2.6

Server:

2ghz quad core Xeon

4gb Ram

2x 146g 15k drives in raid1

TIA

[Baloo]

The first thing that comes to mind is that you've got an endless loop making requests to the fm server.

Try posting the section of the code that causes the server to puke.

In general the two biggest culprits we've found slowing down our PHP API pages have been:

Unnecessary calls to Filemaker. Get really good at compound finds, and if you want related records add a portal rather than running a second find.

Too much clutter on API layouts. Only put what you need to create your page no more no less. Make good use of setResultLayout() when searching on one set of data to obtain another.