yfleury Active Member Licensed User Longtime User Aug 17, 2019 #1 Hi all! When I restore a table from jRDC2 to the app, I sent only a sql request like "select * from table" But when I want to backup App DB to jRDC2 I send it with a sql insert for each row. Is it the only way to copy my data from my app to jRDC2 server?
Hi all! When I restore a table from jRDC2 to the app, I sent only a sql request like "select * from table" But when I want to backup App DB to jRDC2 I send it with a sql insert for each row. Is it the only way to copy my data from my app to jRDC2 server?
Erel B4X founder Staff member Licensed User Longtime User Aug 18, 2019 #2 yfleury said: But when I want to backup App DB to jRDC2 I send it with a sql insert for each row. Click to expand... That's a mistake. You should use ExecuteBatch with a list of insert commands. Upvote 0
yfleury said: But when I want to backup App DB to jRDC2 I send it with a sql insert for each row. Click to expand... That's a mistake. You should use ExecuteBatch with a list of insert commands.
yfleury Active Member Licensed User Longtime User Aug 18, 2019 #3 Thanks Erel I find this https://www.b4x.com/android/forum/threads/executebatch-how-to-use.54175/#post-340103 and I will try it. I suppose I can executebatch for all tables I want to backup to distant db at once. Upvote 0
Thanks Erel I find this https://www.b4x.com/android/forum/threads/executebatch-how-to-use.54175/#post-340103 and I will try it. I suppose I can executebatch for all tables I want to backup to distant db at once.
yfleury Active Member Licensed User Longtime User Aug 18, 2019 #4 I backup all local table to remote DB in one time with executebatch and it's much faster than backup row by row. [SOLVED] Upvote 0
I backup all local table to remote DB in one time with executebatch and it's much faster than backup row by row. [SOLVED]