JDBC very slow with studio 6 on mac

RGreim rg4odev at online.de
Tue Dec 6 13:37:59 EST 2016


Hello,
Omnis doc: ... supporting a type 2 driver inside the java environment 
It's possible to do some settings inside the session page.
Squirrel is a tool written in Java: there is no wrapper in between.
Imho: the jdbc dam is using a wrapper translating jdbc results in Omnis objects.
That means, squirrel is indeed faster. 
Maybe u can tune the java environment, used by Omnis or use prepared statement.
Turn on logging, to see whats really happening behind the scenes.

HTH
Rainer




More information about the omnisdev-en mailing list