I am planning to use this RDC as a temporary server, its purpose only to receive data from a lot of users.
I am concern with its writing performance since it is write to microSD.
When RDC received data from users, before it is committed to a database, I suppose this data is queued in memory. If this true, which settings should I apply in c3po.properties file so it could hold at least 1000 uncommitted records from users?
Also when sending ExecuteBatch Command in RDC, suppose this command contains 5 sql insert statements, and if I have set c3p0.maxStatements=150 in c3po.properties file, this ExecuteBatch count as 1 statement or 5 statements?
Thanks in advance.