>Dear All,
>
>I have problem when loading remote view from SQL-Server which has 3 million records,Grid will display after 100 records fetch, but if I want to search something, I have to wait until 3 million records load into remote view first, than search will complete.
>
>Is there other way ?, need your advice my friends .........
>
>Thanks in advance
>Hendry Setiawan

Create your RV as a parametric view (check filter tab).
Cetin