Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Collate sequence
Message
From
04/04/1999 08:20:45
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Collate sequence
Miscellaneous
Thread ID:
00205049
Message ID:
00205049
Views:
53
I read some threads about set collate and now I'm scared (and sweating).
I use ONLY set collate to "czech" !
Maybe - I haven't problems with speed - because I have little tables (up to 500k rows) ? or 90% of indexes are on integer fields ? or ...
I try run some code under both sequences (with indexing) and the results are (for example): czech 1.8 second, machine 1.65 seconds .. (network traffic make more).
So, rewrite applications or not (many "order by") and can I mix machine indexes with czech collate for order by and (horror) can my applications now lies ?

Pavel
Next
Reply
Map
View

Click here to load this message in the networking platform