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

[BEVERLY VOTH]

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