John and API SDQL Friends,
Here is my current update recipe.
Every 10 minutes on the 10 minutes the server checks for new files.
If yes then the database is rebuilt and the data server restarted.
The rebuild for MLB now takes about 15 minutes.
I will look for speed ups on the backend.
In the meantime I suggest:
1) minimize the data load by deleting any unnecessary fields
2) Time your updates to match the 10 minute cycle: avoid uploading data across the 10 minute marks as this will trigger 2 build-restart cycles.
Sports Database LLC