Design ideas for retrieving Data for Read Only

> Currently I am in the process of evaluating different

> design ideas for the search functionality of my

> application. I am looking for a best option for

> retrieving the data by executing some complex sql

> queries with huge query criteria and showing the

> single or multiple records to the user. But the data

> is read only. This may involve pagination if the

> number of records exceeds the page limit.

This can typically be handled with a Fast Reader, though this is a coding ideom rather than a true design pattern.

http://java.sun.com/blueprints/patterns/FastLaneReader.html

> Please suggest me about a

> good option for this.

Apache Lucene is worth considering,

http://lucene.apache.org/java/docs/

MartinS.a at 2007-7-12 21:49:14 >