Recommended number of DB's using Web Companion

[tgomez]

Using the Web Companion services, is there a recommended maximum number of databases that should be hosted? We are currently running 4 db's on our FMPro web server and hosting up 24 others that are called from other file servers to our web server. Is there a limit before our web server starts having problems? Thanks!

[Vaughan]

Here is my best guess: technically, Web Companion is single threaded, which means that it's only ever doing one thing at a time. While it's doing something for webuser1, all the other web users have to wait for it to finish.

I'd reckon that the number of databases is pretty much not a variable for Web Companion, because it only uses one at a time anyway. What is the limiting factor will be the number of users and the complexity of their requests. The longer a request takes to perform, the more waiting other web users will endure. The limiting factor therefore IMHO will be the response time when the server is busy.

Having said that, there is a limit to the maximum number of files that FMP client can have open at once, but it's an FMP limit not Web Companion. I seem to remember that for the normal client its 32 or 50 or something files, but cannot find the exact reference at the moment.

[Anatoli]

My Unlimited is serving now 30 databases.

The limit is 50 databases and 1-5 TPS depending on complexity and speed of HW.

[yafreax]

we've reached 50 twice now on our FMP 5 Unlimited. I'm pushing for a RAIC system or atleast another computer and Unlimited liscense to split the load up, but even with that many, and a fairly high hit rate, we haven't any problems since i took scripts off some of the sites.

Jeremy

[Anatoli]

Jeremy,

exactly in line with my experience :-)