getting a value from an unrelated table ...

Classic Servoy
1

In an invoicing solution I have a table named “taxes”. Fields are taxDescription, taxRate, taxID.

2 records:
GST, 8%
PST, 7%

In your collective wisdom, what’s the fastest method of getting a tex rate:

  • using the getDataSetByQuery to query the taxes table?
  • doing it the FileMaker way and creating a relationship to that table?

Personnaly I prefer the Query method, but I want to make sure I don’t do anything that will bite me in the behind later.

Wim

2

wim:
In an invoicing solution I have a table named “taxes”. Fields are taxDescription, taxRate, taxID.

2 records:
GST, 8%
PST, 7%

In your collective wisdom, what’s the fastest method of getting a tex rate:

  • using the getDataSetByQuery to query the taxes table?
  • doing it the FileMaker way and creating a relationship to that table?

Personnaly I prefer the Query method, but I want to make sure I don’t do anything that will bite me in the behind later.

Wim

Hey Wim!

Either method will be FAST. The getDataSetByQuery is the most flexible - since you can change your schema. Since you can iterate through the resultset - you can also populate global variables with the result - and use it for the entire session.

I believe it’s a little faster since Servoy won’t have to make the join every time the form is displayed - it would be just a onetime operation.

Just my thoughts,

Bob Cusick

3

-A related foundset is 1 query (if not yet cached and triggered by requesting a value via the relation)
-getDataSetByQuery is 1 query (when invoked the function)

So there is no real difference in performance, only a related foundset is lazy loading, cached and automatic