Some database engines, such as Btrieve, older versions of Pervasive (the new name for Btrieve), and dBase, do not perform multi-table joins very quickly. In fact, in our testing, Stonefield Query can perform multi-table joins an order of magnitude (that's 10 times!) faster than some of these engines. If you find that single-table reports run quickly enough but multi-table reports run slowly, try changing the Stonefield Query Performs Joins setting to True.
Stonefield Query normally uses case-sensitive joins when it joins tables. If you want to use case-insensitive joins instead, add CaseInsensitiveJoins=Y to an [Options] section in SFQuery.INI. For example: