• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC

 
pavankumar iragavarapu
Greenhorn
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can we insert more that 50,000 record in a table
if so please let me know how best we can use the preparedStatement to retrive the values from the table inorder to get less time complexity.
 
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper
Posts: 4968
1
Hibernate Spring Tomcat Server
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In one statement?

Isn't there a limit on how long an SQL statement can be?

-Cameron McKenzie
 
Muhammad Saifuddin
Ranch Hand
Posts: 1324
Android Java Windows
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
this article will help you to select which JDBC objects and methods will give you the best performance.

When using prepared statement pooling, if a query is ad-hoc and will likely never be executed again, then use the Statement object. If a query will be executed infrequently, but may be executed again during the life of a statement pool inside a connection pool, then use a PreparedStatement. Under the same circumstances without statement pooling, use the Statement object.

Selecting Functions that Optimize Performance
By John Goodson
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic