[FX.php List] Are there any FMCakeMix war stories?

[Malcolm Fitzgerald]

On 13/03/2012, at 1:51 PM, Tim 'Webko' Booth wrote:
> IMO, it doesn't really matter how the php code is generated / looked after - the bottleneck is the single-threaded (and 'wordy') nature of either the XML interface or the PHP API.
> 
> Put simply, even small requests will bog down if there are a lot of them. Or if there aren't that many, but there are some large ones thrown in.
> 
> They all try to fir through the same pipe into the database, one after the other. All well and good if the pipe doesn't get too full, but an issue thereafter.
> 
> <snip>

> So, you need to examine how complex your queries are, how often they occur, and how much data will be passed in order to determine which tool is the best to use."

That's food for thought. In the back of my head I know that FMS has it's limits though I haven't run into them yet. 

My concern is that this project may, initially, be handled by FMS but as it grows up it may become too big.  My interest in FMCakeMix is that it would allow us to develop the web app using Filemaker. If the web load does increase past FMS's comfort level we can easily switch to SQL without having to re-code the web site. 

Malcolm



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20120313/2582284b/attachment.html