Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Index
Miscellaneous
Thread ID:
00607646
Message ID:
00607646
Views:
60
Hi!

I've tested the database performance, creating the index::
INDEX ON DELETED() TAG MyTest
The performance was great when I use the databases in just one computer. When I use in multi-user, the result is terrible.

I'd like to know if the problem happens because I was using a function (DELETED()) or because I have just two results (.T. / .F.)?

If I have a field SEX (C) 1 where I have just 2 values too (M and F), but I don't use a function, the problem happens or not? Should I index this field?

[]s
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte
Next
Reply
Map
View

Click here to load this message in the networking platform