Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL select slow on tables shared with VFP8
Message
From
09/01/2005 00:28:03
 
 
To
07/01/2005 08:28:26
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00972500
Message ID:
00975475
Views:
19
Hi Ladislav,

In this scenario, Rushmore optimization is disabled intentionally.

Thanks,
Aleksey.

>My programs works with codepage 1250 (Czech Windows Page), but they share some data on network with the old programs, that my customers use successfuly for several years and nobody want to change them now. That is why I need to select data from DBF files with different code pages in one program (1250,852). The Rushmore optimization does not work in SQL-SELECT from DBF file with CP852. I have tried the command SET ENGINEBEHAVIOR 80 at first, but the Rushmore optmization level was NONE in any case after recompilation by VFP9.
>
>In VFP8 the rushmore optimization worked for both code pages normally as I expected.
>
>I would like to know, if it is a bug or the new intended feature in VFP9.
>In the first case I will wait for service pack. In the second case I must rewrite my programs, because the selects without optimization are very slow.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform