How to increase the Search performance from a Data set in KNIME?

Hi,

A interactive search widget (multi column) knime model is designed to retrive the results from a huge data set, currently this is working with a 12M rows of data which is having aroung 7 columns.

There is a data additon daily happening at the rate of 1M rows to the above said data set. Current performance of the Data retrieval is poor, eventhough the 12M data is kept in a Table and connected directly to the Widget component.

Any suggestion to increase the search performace of this model? Please suggest.

Thanks.