Interesting read. Thank you.
Very Interesting, ...but . The ideal is update, without import of data.
Update Deployed Solutions ( #1 ) 130
The proposal is to update the schema (off-line).
Avoiding updates via data import (precarious update),
... will happen when the app. has a size of 45GB of data?,
... import the 45gb in each update ?
Maybe the ideal update would be without import data, but how the fmp files are designed right now, I don't think this is possible. FileMaker Inc. should think about such technique...
I use it for my vertical market product and my customers are happy how they can update it. They just need to do three things:
- take solution out of server (This technique works only when fmp12 file is not hosted).
- Push the UPDATE button.
- Upload solution back to the server again.
Benroy Business App has more than 100 tables and I have customers who have financial, project management and task management data for 3 years already. The file doesn't weigh GBs, but it has thousand of records. Actually I designed the solution, that all documents are stored externaly (in containers data stored externaly), so when the update runs, it doesn't import files itself, it only import references/links. And the update takes 3-5 minutes, max 10 mins.