Web Companion Speed

[l0cke]

This is FileMaker related but deals with OG. Is there any way to speed up XML queries to the web companion? We are running FMU 5.5 on a Windows 2000 box with dual P3 cpus. Unfortunately with FMU 5.5 we have to disable dual cpu support due to it not completing any query when enabled. We currently only use the web companion for XML queries, perhaps an upgrade to FMU 6 would help?

[digitalpoint]

How many queries per minute are you sending to it?

[l0cke]

Well one example is retrieving records from MainMenu, which contains about 5,500 customers. I have created a custom web security database that excludes all of the summary fields. Time to retrieve one record is about 5 seconds with the following:

http://server/FMPro?-db=MainMenu.fp5&-format=-dso_xml&-Max=1&-Find

[digitalpoint]

What fields are you getting exactly? Anything with a lowercase first letter?

[l0cke]

I am getting a lot of records as I have only excluded the summary fields and a few other miscellaneous fields. For this exercise I am only interested in the following fields:


Customer ID
Account Class
State
Sales Tax Class
Establish Date
Broadband 2
cNew Expiration Date

[digitalpoint]

You're best option would be to create a format file that only included those fields and use that to pull the data, rather than pulling every field from the system.

[l0cke]

Wow.. I wish I had thought of that. It took less than a minute to display the results in a browser window. Still no Oracle database but at least it's bearable.

Thanks :)