There is a limit to the number of concurrent connections with Custom Web Publishing which are listed on the FileMaker Server tech specs:
The limits are 100 for FileMaker Server and 200 for FileMaker Server Advanced. Remember that CWP Connections are based on simultaneous request events, rather than persistent connections and usually only last for a second or two.
Andrew is correct, with one slight correction. Version 12 of Server made a change in how CWP manages connections. They're now maintained for a few minutes (I do not know the exact time), rather than terminating immediately after the request is completed. I'm not sure why, but I speculate this has something to do with a desire for improved performance.
Thank you, databuzz and Mike_Mitchell. Your advices are very helpful.
This is a follow-up on my original post. We evaluate FileMaker as an additional option to expand the capability of the student information system on reporting. Our purpose is to create a web portal that teachers can quickly pull up a student’s performance information (preferably in the charting form). The original idea was to use FileMaker as the backend hosting the data while using PHP for custom reporting. We have 350+ teachers. We envision we may run into connection issue on special occasions with the 200 connections limitation for web publishing. Anyone ran into the custom web publishing limitation?
Not the ideal solution but we can separate the grade levels into different databases. Does the connection limitation apply per server or database instance?
phanh may be in-session,
The CWP (Custom Web Publishing) connections are per FM Server. However, if you aren't setting up session controls in your PHP then each 'connection' is only for the length of time required to reply to the browser. Therefore the connection limitation can usually be ignored unless you set up persistent (cached) sessions or expect over 200 connections in the length of time a query needs to get a response.
Hmmm, a correction is in order,
CWP and IWP each have only 100 sessions. They cannot be combined for a single connection type.
Depending on how the PHP is coded and setup - the session may have an extended timeout or may not time out on its own. You may have to set a specific PHP session timeout or possibly terminate the session in the PHP.
IWP has a session timeout setting, default is 60 sec.