File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

good ways to increase the performance of searching

 
anarkali perera
Ranch Hand
Posts: 237
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
...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.


     
    It is sorta covered in the JavaRanch Style Guide.
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic