Jump to content

cbishop

Newbies
  • Content count

    3
  • Joined

  • Last visited

Community Reputation

0 Neutral

About cbishop

  • Rank
    newbie
  1. xDBC Listener Problems on FMS12/13

    Yes, we've been using a task schedule with "fmsadmin start xdbc" that runs every 15 minutes, and it does indeed keep it online. We also run "fmsadmin restart xdbc" nightly just to flush out any memory leaks from its Java processes.
  2. Years late, but Get(ApplicationVersion) = ("Filemaker Web Publishing" or "Web Publishing Engine") This would always be false anyway. The ("Filemaker Web Publishing" or "Web Publishing Engine") is an expression on its own, and would equate to 0. You are basically asking if Get(ApplicationVersion) = 0. That is, unless you were just giving us a loose example of what you were trying to do. :-)
  3. As far as the original search, I find that searching any related tables is unnecessarily slow. It seems to search all records and then push through to the current table. What I do to speed it up - especially when constraining from a smaller set of records - is to create an unstored calc field in the table you're searching in. The calc would get the contents of the field you want to search for in the relationship. So if you're in TABLE_A, and you're constraining using TABLE_B::STATUS, create a new field in TABLE_A called STATUS_CALC, and then formula is TABLE_B::STATUS (unstored). Now perform your constrain on TABLE_A::STATUS_CALC instead. I've had searches that were taking up to 3 seconds now perform almost instantly.
×

Important Information

By using this site, you agree to our Terms of Use.