what is the best practice for performance tuning in filemaker pro 17 ?
Where are the edits happening? On the wordpress side? Or on the FileMaker side? Do the Wordpress tables keep track of when changes were made? If yes, it's a matter of creating a new table to store when the last sync was done.
If you are constantly deleting all 100k records and recreating them, that is why it takes 10-15 minutes. That ESS connection ( if that is what you are using ) is not fast.
Another option may be to do an ODBC import. That may be faster, but I have not done that a lot, so others would need to chime in on that.
There are several "old" threads if you search for 'performance tuning' on this forum. Here's one:
Perhaps these threads will help you describe more of what you seek?
Performance tuning in FileMaker is mainly about hardware, network, and custom app design. All based on users, workload, usage.
Basically i have a database of 100k records and around 50 tables. Filemaker database is attached with wordpress site and sync the data on schedule but its taking too much time to execute its around 10 to 15 minutes. To minimize the duration i have converted calculation fields of every table into stored but the problem is remain.
Thank you for helping me. i will explore it
Is your "sync" copying all the data on every sync? Or are you narrowing the sync to only data that has changed?
first its deleting the all data and then sync .
is there any way to narrowing the sync which is changed ?
There is definitely a lot to what makes FileMaker fast. Here is a video of my session at DevCon where I talk about some of things to consider.
Performance Tips for Beginners [BEG 10] - YouTube
The editing is happening on filemaker side, around 10 users are working on and some of them are salesperson so they keep making sales and we are updating these data into WordPress . we have different charts on website to show stats.
The solution you provide to check the last modified time is considerable i will test it. Thank You.
Retrieving data ...