• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Rob Spoor
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Tim Holloway
  • Piet Souris
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Frits Walraven
  • Himai Minh

good ways to increase the performance of searching

Ranch Hand
Posts: 237
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.

    Ever since I found this suit I've felt strange new needs. And a tiny ad:
    the value of filler advertising in 2021
      Bookmark Topic Watch Topic
    • New Topic