[FX.php List] ODBC Selects and Inserts VS FX/XML Speed test

[John Funk]

The ODBC calls were hardcoded directly to the Driver.
Thanks

On 8/20/12 8:23 AM, "Dale Bengston" <dale.bengston at gmail.com> wrote:

> Hi John,
> 
> Thanks for the metrics. I think it's comforting to see numbers backing up what
> we've known for some time about FMS/XML speed.
> 
> Did you use FX.php to perform the ODBC calls, or did you hard-code the SQL?
> 
> Thanks,
> Dale
> 
> 
> On Aug 16, 2012, at 12:40 PM, John Funk wrote:
> 
>> ODBC Selects and Inserts VS FX/XML Speed test
>> Just thought I would share my results of some tests I ran on a NEW fmserver
>> (Win2008)that was installed at my client. The FM server is part of an offsite
>> server bank. It is FileMaker Server 11.
>> 
>> The tests were comparing read and write speeds using the two technologies
>> from a command line PHP script. I also wanted to see the impact on the
>> FMserver's statistics.
>> 
>> The script was designed to find specific records from a large FM DB, in this
>> case the result is about 5000 records out of 980,500 records. No other users
>> were on the system at the time.
>> 
>> Test 1, using FX/XML, Find records = 20 seconds ave.
>> Test 2, using FX/XML, Find records, write to a text file = 21 seconds ave.
>> Text 3, using ODBC/SQL, Select records = 8 seconds.
>> Text 4, using ODBC/SQL, Select records, write to a different DB on the same
>> server = 27 seconds ave.
>> 
>> As you can see ODBC is much faster and ODBC is a direct call to the FMServer
>> engine rather than the web server that XML relies on.
>> A downfall of not using FX is you cannot call FM Scripts to run but this can
>> be worked around I suppose.
>> 
>> I am looking forward to any comments anyone has on this.
>> 
>> John Funk
>> Critical Solution
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> 
> 
> _______________________________________________
> 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://mail.iviking.org/pipermail/fx.php_list/attachments/20120820/f71b0a8b/attachment.html