File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC" Watch "JDBC" New topic


pavankumar iragavarapu

Joined: Nov 01, 2006
Posts: 3
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

Joined: Aug 26, 2006
Posts: 4968

In one statement?

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

-Cameron McKenzie
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1323

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

[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
I agree. Here's the link:
subject: JDBC
It's not a secret anymore!