FM ODBC is slow like...

[demiurgen]

when i do sql queries to filemaker using a php file that connects with ODBC it takes forever to get the results out.

is this something i have to live with or can i make this go faster???

[Søren Dyhr]

I keep hearing this, perhaps ODBC is not the most obvious choise here. Why is it you wish to use filemaker as SQL system??

As you will notice, do I always proceed my line of questioning this way, if I think it's beyond the realm of usual filemaker utilization, it's not to be impolite ...but a lot of questions originate from a lack of willingness to follow the filemaker discourse ...the reasons are many but, usually is it persons drilled in SQL approaches, seeing themselves lowered down to this "inferiour" tool - dissagreeing with management decisions.

But honestly does whichever tool you may pick, require you understand the gist of it - and not apply the "Use-a-tennisracket-to-make-french-fries" approach. If management is wrong tell them!

--sd

[demiurgen]

i am a total newbie in filemaker and yes i am drilled in SQL

i want to make a jobtracking system. where anyone with a username and password can log on and see the status of a job.

if anyone know of a better way of doing this please let me know

[Søren Dyhr]

An awful lot makes a living developing such, and to be frank hardly ever involving filemakers ability to act as ODBC source:

http://www.seedcode.com/cp-app/ste_cat/seedcodecontacts

http://www.filemaker.com/products/applications/index.html

--sd

[demiurgen]

i dont want to use anything other than filemaker server. everything else must go through a browser.

just a simple database with jobs and the client can connect with their browser, login and see only their own jobinformation.

so all i have and all i want to use is filemaker server and php...

[Søren Dyhr]

Ah I havn't seen that you mean the tool designed for IWP/CWP services! It's not filemaker server as you write in your text but instead Filemaker Server Advanced.

You will need something like this:

http://www.filemaker.com/developers/resources/php/index.html

or

http://www.iviking.org/FX.php/

Sorry to have taken you on this picknick!!!

--sd

[Wim Decorte]

If you don't want to use some FMP clients, why use FileMaker at all? FMSA allows xDBC and XML access but it is not designed for those to be the primary access methods.

In that case you'd be much better off with using mySQL or SQL Server or something similar.

[demiurgen]

offcourse! i think it would be wiser to use mysql for something like this...

BUT! the company i am working for is already using filemaker databases and all the information i want is in these filemaker databases.

i want our clients to log on over the internet and check the status of their jobs. and that status is already in place in filemaker, cause that is what we use in my company...

anyway! with the new php api i dont need odbc.