[FX.php List] 7.0 Server Advanced w/Apache on Windows

[Jason H Awbrey]

Hi Etienne,

1) You can only use FMSA7/8 with IIS on a Windows box. I would much  
rather deploy with Apache but that's the way the cards fall for now  
(unless you deploy the WSM on a Mac!).

2) I just finished a very large project and it scales beautifully.  
The problem that you are most likely experiencing has nothing to do  
with FX.php but with WPE itself. We have had several solutions where  
there was a "bottleneck" when doing queries against FMSA7/8 via the  
XML interface. We were seeing a lag of around 7 - 15 seconds before  
FMSA would respond to the request. The only way we found to resolve  
the issue was to move the core tables to an external file and only  
query that file. The main file could look to the web file for related  
info but not the other way around. After we did this, our average  
query was no more than 1.5 seconds. I must note that the table  
occurrence graph in the main file is pretty intense.

We talked with several FileMaker SEs about the issue, had the issue  
escalated to an engineer who finally confirmed there is a bug,  
although I'm not sure I ever saw what it was they confirmed was a bug 
(??!?!?).

3) I am definitely not the xDBC guru but I have definitely run it  
through a few tests. A number of people I talked with are doing  
something very similar with the separate file to get better  
performance out of the xDBC engine. It is almost as if the WPE is  
trying to negotiate the entire TOG when it queries the file.  
Simplifying the file seems to simplify the structure and allows the  
WPE to return the data faster.

HTH,
Jason

~-~-~-~~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
Jason Awbrey
Web Integration
FileMaker 7 Certified Developer
Harmonic Data Associates
http://www.harmonic-data.com
jawbrey at harmonic-data.com
w - 214 269.2804
~-~-~-~~-~-~-~-~-~-~-~-~-~-~-~-~-~-~



On Jun 12, 2006, at 6:35 PM, Etienne Le Sueur wrote:

> Hi everyone,
>
>
>
> I have been a subscriber to this list for a fair while now - lots  
> of good help here…
>
>
>
> Anyway, I have a few questions…
>
>
>
> 1)       Is it possible to run FM 7.0 Server Advanced on Windows XP  
> with Apache? I know version 8 seems to have this ability, but I  
> don’t have version 8.
>
> I would prefer to not have to install IIS if I don’t need to.
>
>
>
> 2)       I am about to take a on a rather large project which could  
> potentially involve FX.php, and was wondering if this solution is  
> going to scale well for many users.
>
> I have built a site based on FileMaker using FX.php, and fetching  
> records seems to take a significant amount of time. The server  
> hardware is a Dual G5 w/2GB of RAM, so I doubt that is an issue.
>
> It takes on the order of seconds to process a request of merely 50  
> or so records. This is what gives me concern when I think about  
> taking on a larger project with FX.php
>
>
>
> 3)   Why is the FM Server Advanced ODBC connectivity option not  
> used? I attempted to use the FileMaker Pro 7 ODBC driver with PHP  
> and it was extremely slow – Is this the reason that XML publishing  
> was seen to be the way to go when working with FileMaker and PHP? I  
> haven’t tried the Server Advanced ODBC driver yet.
>
>
>
> If anyone has some suggestions or ideas about these, I would  
> appreciate your input.
>
>
>
> Thanks
>
> Etienne Le Sueur
>
> http://www.jet-age.co.nz
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list






-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20060612/bff3e439/attachment-0001.html