Dim jo As JavaObject = pool
jo.RunMethod("setMaxPoolSize", Array(1))
jo.RunMethod("setMinPoolSize", Array(1))
Is this correct? Because in my tests, that appeared to slow down the jRDC server.
If I leave the default value of the pool, it returns results faster when I do multiple queries.
Also, any other tweaks I could perform to improve the performance? For example, is there a way to cache queries?
I'm doing some performance tests, and I can insert 10K rows in 900ms with jRDC2, but on a local network.
Querying a quite complex statement with multiple JOINs, I get the result in 500ms.
Querying a simple statement, I get the result in 60ms.