Web Companion Speed

Discussion in 'Optigold ISP' started by l0cke, Jun 8, 2004.

0
  1. #1
    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?
     
    l0cke, Jun 8, 2004 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    How many queries per minute are you sending to it?
     
    digitalpoint, Jun 8, 2004 IP
  3. l0cke

    l0cke Active Member

    Messages:
    178
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    73
    #3
    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
     
    l0cke, Jun 8, 2004 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    What fields are you getting exactly? Anything with a lowercase first letter?
     
    digitalpoint, Jun 8, 2004 IP
  5. l0cke

    l0cke Active Member

    Messages:
    178
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    73
    #5
    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
     
    l0cke, Jun 8, 2004 IP
  6. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #6
    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.
     
    digitalpoint, Jun 8, 2004 IP
  7. l0cke

    l0cke Active Member

    Messages:
    178
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    73
    #7
    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 :)
     
    l0cke, Jun 8, 2004 IP