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.

See Also

Configuration Settings