How should I make searching a relational database more efficient?

Posted by Travis J on Programmers See other posts from Programmers or by Travis J
Published on 2013-11-12T00:42:55Z Indexed on 2013/11/12 4:14 UTC
Read the original article Hit count: 373

This is in the scope of a web application. I have a database which has a few nested relations. There is a feature which depicts the history of a large chain of relations. It is essentially a data analysis feature. The issue is that in order to search, a large object graph must be loaded - the loading time for this object graph is not quick enough to be viable. The problem is that without loading the whole graph it makes searching from a single string nearly impossible. In order to search, explicit fields must be specified and the search data supplied.

Is there a design pattern for exposing the data in a way which facilitates a single string search instead of having to explicitly define parameters?

© Programmers or respective owner

Related posts about database-design

Related posts about search