What is the most efficient methodto insert records in a table, to use an updatable RecordSet or to use a PreparedStatement?
PreparedStatement is smally quicker than updatable RecordSet. An updatable RecordSet is quicker than PreparedStatement if you insert into more than 200 columns with constant values. It can only cope with constant values. PreparedStatement can cope with complicated expressions so that you can insert timestamp, function, ResultSet, and so on.
Related Questions
- If records are added to the CallList table on the fly while a campaign is running and the campaign is using a filter to select the records. How do the new records get picked up?
- What is the most efficient methodto insert records in a table, to use an updatable RecordSet or to use a PreparedStatement?
- What is the difference between the Original Golf & Billiards Combo Table and the Original Golf and Table Tennis Insert?
