I have 2 questions concerning retrieving data via ODBC.
(I am using VFP 3.0b)

1. Is there a way to fetch data quicker? I have a remote view against a Sybase database. I pass it 2 parameters, year and week. The view takes about 2 minutes to retrieve the 25000 records. Is there a way to get at this quicker. Unfortunately, this is just the first step. I then need to run another query off this data set, therefore I need it to fetch all records before proceding.

2. Rather than using remote views, are there any ways to access the Sybase tables directly and not use a view.

Thanks in Advance.

Scott