• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Q&A

Q1:In view of the fact that it is possible to do calculations in SQL queries, is there a rule of thumb about whether it is better to do necessary calculations in queries or after data is imported into FileMaker?
A1: There is no hard-and-fast answer to this, but some guidelines may be useful. First, if the calculation is already created in the external database, you might as a well use it (unless it is also created in your FileMaker database). Second, databases running on large database management systems may be faster than FileMaker. However, you may also want to get in, get your data, and then get back to FileMaker so as not to add a burden to the external database.

There definitely is a significant advantage to selecting data on the external database so that you extract as little as possible, thereby minimizing processing and data transfer needs.

Q2:Where can I get more drivers?
A2: You need an ODBC driver for a specific database and the platform on which it is to run. The first stop should be the database vendor itself (or, if you are in a large organization, your internal IT department or data management area).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint