Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Large table
Message
From
11/07/2003 11:18:20
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00809158
Message ID:
00809218
Views:
38
Yuri,

The ODBC driver still has to open the table, and do the same work. This only adds another layer on the client side.

And Chris, just because the table is open, doesn't mean VFP had to pull the entire table across the line. Of course that is not much of a consolation to you, because it still is too slow.


>Then REMOTE view should help. Something like:
>
>create data hi
>create connection vfphello connstring (;
> 'Driver={MICROSOFT VISUAL FOXPRO DRIVER};'+;
> 'SourceDB=C:\Foxwork\Vfpapps\;'+;
> 'SourceType=DBF')
>
>CREATE SQL VIEW hello REMOTE connection vfphello share aS;
>SELECT *;
>FROM RECLIST;
>WHERE nIDnumber = 1234567
>
>use hello && table is not open
>
>>We choose the specific record based on a field name nIDnumber; the table is indexed on this field.
>>
>>This is what I tried:
>>
>>OPEN DATABASE DBNAMES
>>
>>CREATE SQL VIEW ViewOneRecord AS;
>>SELECT *;
>>FROM DBNAMES!RECLIST;
>>WHERE nIDnumber = 1234567
>>
>>
>>However, if I "DISPLAY STATUS", I find that the big table is open (as well as the database).
>>
>>CM
Steve Gibson
Previous
Reply
Map
View

Click here to load this message in the networking platform