Hi!
Well, how mouch records in that table on SQl Server? If there are large number of records, the only reason I see is that remote view used fetching when you created it (so not all records are downloaded from the server). In the application you probably use something like scanning of view or call to RecCount() function that force fetchable remote view to download all records from the server, so that process is slow. On my machine I can get near 10,000 records/second from the average table, when filtering specified - some time could be spent for filtering.
HTH.
>Is that normal ?
>
>I use Win98, MSDE, Visual Foxpro 7.0. I work with remote views in my application. After creating the connection, and a simple view to specific table on MSDE, the connection to the sql-server is fast. But when developing and testing the application, each time when a view is opened, the "opening" time of the view is a little bit slower (approx. 3 to 5 seconds).
>
>If I delete the connection and rebuild the connection, the "opening" time of the view is fast again.
>
>What can be possible reason for that ?
>
>Bye,
>-Andreas
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.