This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Five Lines of Code and have Christian Clausen on-line!
See this thread for details.
Win a copy of Five Lines of Code this week in the OO, Patterns, UML and Refactoring forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

good ways to increase the performance of searching

 
Ranch Hand
Posts: 237
  • 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?
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • 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.


     
    Did Steve tell you that? Fuh - Steve. Just look at this tiny ad:
    Thread Boost feature
    https://coderanch.com/t/674455/Thread-Boost-feature
      Bookmark Topic Watch Topic
    • New Topic