Scott,

The first thing to do is make sure that your view is set to retrieve all the records at once (FetchSize=-1). The default is 100 at a time and this slows things down quite a bit if you're retrieving a lot of records. Of course, you should really try to reduce the number of records you're retrieving and retrieve only the fields you need.

You can use SQLEXEC() to send a SELECT statement to Sybase. This is more flexible and maybe a little bit faster, but it's still using ODBC and you probably won't see a big difference in performance.

>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