Hello ESS gurus,
Upon migrating our MailOrder solution from V11 where we were successfully pulling our website orders into a local table from the mySQL table of weborders, we've seen what seems like a behaviour change with the ESS of V12 that leaves us perplexed.
The mySQL table has some 11K records and we're needing to dowload only the most recent. The number per day can be anywhere from a few to over 40 depending on how actively our customers are ordering. The V11 script steps we use for finding the lstest orders are shown here:
When we try to use the same script with V12 there's an interminable wait while the latest records are found on the cart1_order mySQL table. It took some 10 - 15 seconds with V11 (which was usable) but more than 20 minutes in V12, making this method of extracting orders from our website unsuitable for our migrated solution.
Our workaround is to continue using the V11 file for the ESS access, exporting the records as a couple of text files (WebOrders & WebOrderItems) then importing those records into our V12 solution.
I've checked our setup of the DSN in the ODBC Managers on the two server installations and the settings are identical for each version.
We're using FMP 11.0v4 and FMP12.0v3 on Mac OS X 10.8.2 or 10.6.3. FMS 11 is running under Mac OS X 10.6.8, while the OS for FMS 12 is OS X 10.8.2.
Has anyone else encountered this issue?
Your contributed experieces will be appreciated.
Hamilton, New Zealand