MySQL Record Difference, and Dead slow connection, and missing existing records
I am conneting FM to PrestaShop MySQL Tables.using Opensource ODBC, And come up with some difficulties.
Comparing Qty of records in the Prestashop ps_access Table, there are 79 records, FM only see's 64, then later only 44. (see tiff)
Whereas Navicat shows all Tables and records instantly, FM is "DEAD" slow.
and FM seems to start mising MySQL records (only sees 44) of the 79 existing records??
And this ps_access is ONLY 1 connection, not even all PrestaShop Tables !!!
Ideal would be fast import / export of products and Orders, having FM as semi-live "backup" of Online MySQL.
2th I need help with importing and exporting scripts, so in order to Import and Export Data, Filemaker does not want to import or export correctly using the MySQL Query