PHP API very slow and resource demanding

[serzone]

Hi Everyone,

I ran into a problem with the PHP API for filemaker and the filemaker server.

I wrote a basic script that uses a local account to query a table in the database that has 45 records. the layout I'm hitting is stripped down to just the fields I need (about 8).

Whenever I load that page it takes about 3 seconds to return the results. If I have 2 simultaneous users it goes to 10-16 seconds to load the page, for both users. The CPU goes to 50%. On just a basic query. Why?!

I'm running Windows 2003 sp2. 4GB RAM, Dual Core AMD Opteron 2.81Ghz (2CPUs). There is nothing else running on this machine.

FileMaker Server 10 with latest update without IWP, ODBC. XSLT is disabled as well.

Ideas? Suggestions?

[Peter (duksis3)]

I suppose - nothing is wrong with FM Server

Test the site from other machine.

What is your web-server?

But honestly - switch to Mac.

[serzone]

Ok... I was able to improve (dramatically) the performance. here's how (and i should've thought about this earlier):

1. new layout for web based on TO that doesn't have ANY relationships

2. removed a calc field from layout that used the List function to bring in some info from a related table. (this was the big gain in performance)

[Genx]

But honestly - switch to Mac.

But honestly... really? You want to switch from a stable industry and enterprise standard just because it's not a Mac? Please try and make informed statements rather than just fanboy-esk ones.

FYI the issue is having Java as a platform for XML generation not the OS and you are not likely to see any performance improvement if you switch to Mac.

[serzone]

I agree... ever since they switched to java the server product seems to have steadily declined in quality and reliability.