I'm using ESS to pull data out of a readonly MS-SQL database. One table has 600,000 records. I recreated the fields on a native table and then use a simple script that collects the names of the fields on the ESS based layout then pushes the data via create new record in the FMP table. I loop through the records. I can get about 18,000 records across then Filemaker blows up. If i try and export to Excel or to a new Filemaker file it blows up. (Here's some of the crash code
Process: FileMaker Pro 
Path: /Applications/FileMaker Pro 14 Advanced/FileMaker Pro Advanced.app/Contents/MacOS/FileMaker Pro
Version: 14.0.3 (14.0.3)
Code Type: X86-64 (Native)
Parent Process: launchd 
Responsible: FileMaker Pro 
User ID: 501
Date/Time: 2015-10-30 12:34:49.701 -0400
OS Version: Mac OS X 10.9.5 (13F1112)
Report Version: 11
Anonymous UUID: 83B1188F-21CE-738A-B030-CAB817543799
Crashed Thread: 0 Dispatch queue: com.apple.main-thread
Exception Type: EXC_BAD_ACCESS (SIGSEGV)
Exception Codes: EXC_I386_GPFLT
Luckily the records have dates so I've limited them to a date range and got the found set to around 15,000 per go and I can move them over but that will take a while. But let it try and handle the 600,000 at one time it crashes big time.
On FMPA 14.0.3, on a Mac running 10.9.5 on 8 Gigs Ram .I am using Actual ODBC Driver for SQL Server V3.3.4.
If you one has seen this or have a reason this might be happening let me know.
UPDATE. It crashed after only 9,000 records. This will take some time.