Meaningless Drivel is fun!*
The moose likes JDBC 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
Bookmark "JDBC" Watch "JDBC" New topic
Author

JDBC

pavankumar iragavarapu
Greenhorn

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
    
    1

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: 1321

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


Saifuddin..
[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC