Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rushmore and collate
Message
 
To
27/03/1999 17:50:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00202772
Message ID:
00202817
Views:
12
Hi Bela,

>Can Rushmore use indexes made under different collate sequence than the current one?

No. Rushmore can only use an index that has the same collate sequence as currently is active, because the collate sequence determines how strings are compared. And any other collate sequence beside MACHINE is usually slower, up to 80%. Beside that, the GENERAL collate sequence has a lot of bugs, for example it doesn't work reliable at all with numeric, especially with integer expressions.

Christof
--
Christof
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform