[FX.php List] FX.php and SQL queries against FMSA 8

[Jason H Awbrey]

John, Joel and Chris,

Thanks for the answers. Just so I don't sound like a total nut case,  
let me elaborate a bit. I have a solution that is tied to an ENORMOUS  
FileMaker system. Due to the complexity of the system, the CWP  
interface via XML/FX.php is slower than (I believe) it should be.  
Query times at this point are in the 7-12 second range. That's about  
6-11 seconds waiting for FileMaker to respond (work through the  
metadata) and then ~1 second to return the XML. There have been some  
version updates that could give us a performance boost, but I won't  
get to implement those until I move everything to a new server tomorrow.

Now that Chris has added the ODBC features to the FX.php class, I was  
thinking it would be easy to test and see if the ODBC interface would  
be any faster than the XML interface by simply changing my queries to  
use the ODBC query string. It is understood that under normal  
circumstances the ODBC interface would be a bit slower than the XML  
interface due to the information that it has to return. The thought  
would be to create an ODBC interface file with an abstracted TOG of  
just the TOs we would need access to.

If that doesn't get  the desired results, I've got a trick or two  
more up my sleeve using XML, they're just a bit more involved. I'll  
bark up that tree when I get there...

Isn't optimization fun?!?

Cheers,
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 Apr 4, 2006, at 7:28 PM, Chris Hansen wrote:

> Jason,
>
> Of course I have; I built the thing =)  Granted, I should echo what  
> others have said about performance, but you can do some cool things  
> (e.g. updating every record that matches specified criteria, etc.)   
> And, I didn't find performance to be THAT much slower than  
> accessing FileMaker via the XML interface.  In the case of ODBC,  
> your DSN is entered using SetDBData(<DSN>).  Seemed the most  
> logical use of FX syntax for an ODBC connection.
>
> Just FYI, setting everything up on Mac OS X (as opposed to Windows)  
> can be hairy (or was when I did it) because of differences in the  
> way that the ODBC drivers are set up in the OS versus PHP.  (That  
> may have changed by now, though.)
>
> Best,
>
> --Chris Hansen
>   FileMaker 7 Certified Developer
>   Creator of FX.php
>   "The best way from FileMaker to the Web."
>   www.iViking.org
>
>
> On Apr 4, 2006, at 3:52 PM, Jason H Awbrey wrote:
>
>> Hello all,
>>
>> Has anyone used FX.php to query FileMaker via the ODBC interface?  
>> It seems as though I would need to specify a DSN somewhere but  
>> don't see anywhere I would be able to do that. Does anyone have a  
>> simple example they could share that could get me pointed in the  
>> right direction?
>>
>> Cheers,
>> Jason
>> _______________________________________________
>> 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