B4J Question [SOLVED] jRDC2 backup app DB to distant jRDC2 server

[yfleury]

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]

But when I want to backup App DB to jRDC2 I send it with a sql insert for each row.

That's a mistake. You should use ExecuteBatch with a list of insert commands.

 

[yfleury]

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]

I backup all local table to remote DB in one time with executebatch and it's much faster than backup row by row.

[SOLVED]