A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
good ways to increase the performance of searching
Joined: Sep 10, 2009
Nov 04, 2009 10:25:36
i foung when we searching a value in a database table indexing is good approach.is there any other ways to do this?
Joined: Apr 14, 2004
Nov 04, 2009 10:40:08
...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:
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.
Have you checked out
subject: good ways to increase the performance of searching
Interview question: write a binary search method and assume the array is unsorted
OutOfMemoryError While loading the indexes
Implement DB design in hibernate
Clustered index on a DB table
Quickest way to create objects from XML....
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015