overhead: - only at server startup - not on each request (of course) - ipData.prg automatically backs up the whole existing database - and restores if anything goes wrong during the process (global try catch + each sub-method returns .T. / .F.) - backup takes a while: 5-6 secs. for app. 600 Mb - restore (very) seldom happens, mainly during tests on the test site. - checking per se is very fast, less than a second - could not really tell, almost instantaneous - probably because we have a custom program compared to a standard procedure like SDT
memo fields: by default, if record modified on both sides, web data has precedence (this choice because web data are often modified by clients) you have a shell method(table, field) where you can override this behavior for each (table, field) couple. Thierry Nivelet FoxinCloud Give your VFP app a new life in the cloud http://foxincloud.com/ Le 20 déc. 2014 à 14:55, Jeff Johnson a écrit : > Terry: Thanks for that. Two questions, is there any overhead on the web app > running ipData.prg? For example, Stonefield's checking to see if tables need > updating has overhead if the database and tables are large. Second is do > your memo fields merge or overwrite? Many of my memo fields have time > stamped notes and overwriting would not be an option. If someone on the web > enters a note and someone on the local computer enters a note, we need both > of them. > > Thanks! > > On 12/20/2014 3:23 AM, Thierry Nivelet wrote: >> We just installed a FoxInCloud application with this feature ... >> >> Web site: upon startup, web app runs a program (ipData.prg) that adjust the >> database and tables structure if needed (including views and stored procs) >> >> Local: a small VFP exe (ipMigrator.exe) doing this: >> >> 1- downloads ipData.prg from the web site, compiles and execute >> (ensures that both sides have the very same database structure) >> 2- imports data from existing reference tables into the DB >> (until other desktop apps have migrated to the new structure) >> 3- synchronizes data between local and the web site databases >> (using a class supplied by FoxInCloud, 3 lines of code) >> >> Here is the database diagram: >> ftp://foxincloud.com/Screenshots/MCTG/ip.dbc.png >> >> I can give you any other details you would like, including source code, just >> let me know >> >> Thierry Nivelet >> FoxInCloud >> Give your VFP app a second life in the cloud >> http://foxincloud.com/ >> >> Le 19/12/2014 15:27, Jeff Johnson a écrit : >>> When using something like Web Connection, is it better to use free tables >>> rather than a DBC? Without the DBC you have more flexibility when changing >>> file formats and I am not using any views on the web programming. >>> >>> TIA >>> >> >> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
