Poor performance when committing on a Connection to a MS Access database
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   Jeroen_vO
Posted On:   Tuesday, April 17, 2001 01:53 AM

I have a connection to a MS-Access database using the JDBC-ODBC bridge. When a process a single update and want to commit this change, it takes about 2,5 seconds. I believe this is a very poor performance. I also tried a native JDBC driver, NetDirect JDataConnect, for MS-Access but it still takes up 2,5 seconds. What can I do to make my program perform better? It needs to run on laptops which are not state of the art, so substituting MS-Access with Oracle is out of the question. Am I doing something wrong? I Postgresql a good alternative?

Report | Quote This | Send private message | Reply | Print

Re: Poor performance when committing on a Connection to a MS Access database

Posted By:   michael_gallagher  
Posted On:   Wednesday, April 18, 2001 06:51 AM

Have you set auto commit off on your connection "conn.setAutoCommit(false);")? If a connection is in auto-commit mode, then all its SQL statements will be executed and committed as individual transactions which makes things much slower. Hope this helps.
Mike
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact