CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Location
    Guatemala
    Posts
    1

    Unhappy Informix JDBC Performance

    HI,
    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")
    and
    conexion.setAutocommit(false)
    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?
    Thanks

  2. #2
    Join Date
    Jan 2011
    Posts
    24

    Re: Informix JDBC Performance

    Accessing from command prompt is always fast in my opinion. you can get better performance form JDBC by using PreparedStatement, in case if you are not using already, doing batch inserts or update , etc. not sure if it helps but something to think if you are not implemented already.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured