I have some time working with Informix (IDS V 9.4), we made an application using Java Swing, so we used JDBC , but I have realized that the performance of Jdbc es a lot slower that using the commands of sql in odbc or directly in dbaccess, for example executing :
stmt.execute("BEGIN WORK")
it should work the same but it doesn't and BEGIN WORK works much better, so I think that jdbc sets some parameters by default but I don't know wich ones.
Does anyone have some experience with this and could tell me what I should do?