We are currently evaluating the ODBC driver for BigCommerce 2.4.  Our products table in BigCommerce Enterprise has 500,000+ records and would like to query it.  We are using a criteria in our query to display 1 product or 1 SKU but it doesn't show up (or never shows up because it takes forever to load which we end up cancelling).  Is this because the driver will cache the products table locally before applying the criteria?  What's the optimal record limit to have a quick response when doing queries?