SQL views are generally exceptionally fast if optimized regardless of table size. I am fairly certain UT members can help with your problem, but it would be much easier if you posted your SQL code in your message. I use ODBC on remote views and I also have local views and parameterized views. All work very quickly. Don't give up yet.
Mark McCasland
Midlothian, TX USA