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

[John Funk]

Thanks for the tips Beverly.
I DID use PHP on the command line of Terminal of MacOS, this also works on
the DOS prompt on Windows, My application is calling the PHP and using the
results in another program that does not have internet connectivity.
I am finding that my script is evolving into an hybrid of FX calls and
direct ODBC calls. Though is does make your brain hurt...


On 8/20/12 10:09 AM, "BEVERLY VOTH" <beverlyvoth at gmail.com> wrote:

> thanks, John! so you did not use PHP or other web app to make the ODBC calls
> to FM?
> 
> I did a few projects with ColdFusion (I know I know, sacrilege on *this*
> list!) with ODBC to FMS. I have to say I really like the "zippiness". :)
> 
> But with any database and any web application, I still try to OPTIMIZE by
> * caching things that don't need a direct db call every time (product
> description text in a cart, for example can be pushed to an include once - or
> when changed) and called from the web-app instead of the database
> * caching common value lists (state abbreviations and names, for example, or
> any list that doesn't change frequently)
> * storing images NOT in db, but let the web server do what it does best (serve
> FILES of all types), by referencing the location
> * let the web app do the "heavy lifting" (instead of scripts, use the web app
> - and YES, I know that's *more* work...)
> 
> These tips bring up the speed every time, whether using ODBC or xml!
> Beverly
> 
> 
> On 20 Aug 2012, at 10:26 AM, John Funk wrote:
> 
>> 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
>> _______________________________________________
>> 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