I have a form where the user can navigate and edit the records. The user can also set up some filters on such criteria as the dates, the response code, etc. He can enter 0, 1 or many criterias.

Currently, I'm setting a filter on the table itself. It work, except when doing a SKIP -1 or SKIP +1 at the top or end of the table, it take about 2 minutes to return control. The filtered table is also ordered.

I can't use a SELECT-SQL because the user can edit the record. As for a view, I can use it with parametized fields, but I don't see how I can use a parametized view when it's not sure that a given field will be filtered.

The only thing I see for now, is to create a view programmaticaly everytime the user modify the filter. Before going into that option, I was wondering if anybody know a better solution or this is the only option available to improve the speed.

TIA