File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes good ways to increase the performance of searching Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "good ways to increase the performance of searching" Watch "good ways to increase the performance of searching" New topic
Author

good ways to increase the performance of searching

anarkali perera
Ranch Hand

Joined: Sep 10, 2009
Posts: 237
i foung when we searching a value in a database table indexing is good approach.is there any other ways to do this?
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

...this is also a way of degrading insert/update/delete performance. There are no panacea to good performance, otherwise such options would be on by default.

An answer to your question could be very large. A few things that spring to mind:
  • Denormalizing data
  • Deploying your database in a cluster
  • Using more powerful database server(s)
  • Getting more bandwidth between your client and the database
  • Making sure statistics are well maintained
  • Sending extra instructions to whatever query engine your database uses (if this is supported)
  • Breaking large queries down into smaller queries and doing more work in the client
  • Use query hints (if your database supports this)
  • Increase the temporary space available in your database (if your database requires this)
  • Don't use functions
  • Don't use transactions
  • Avoid correlated subqueries if possible


  • and so on.



    JavaRanch FAQ HowToAskQuestionsOnJavaRanch
     
    I agree. Here's the link: http://aspose.com/file-tools
     
    subject: good ways to increase the performance of searching