HXTT JDBC Products: MS Access JDBC, Cobol JDBC, DBF JDBC, MS Excel JDBC,CSV JDBC, Text JDBC, Corel Paradox JDBC, PDF JDBC, Word JDBC, XML JDBC

Performance: 1 second per update--speed up?	Dave Briccetti	2007-09-06 22:35:18
Hi. Our updates are taking almost one second each. Does this sound normal? How can we speed this up? Thanks.
Re:Performance: 1 second per update--speed up?	HXTT Support	2007-09-06 22:48:53
What's your sql? What's the row count of your table? An update sql need to do full-table search if there's no suitable index expression.
Re:Re:Performance: 1 second per update--speed up?	Dave Briccetti	2007-09-07 00:52:06
Remarkable what a difference using PreparedStatement makes. MUCH faster. Problem solved. Thank you.

Email: