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