Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date indices - what is best ?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Date indices - what is best ?
Miscellaneous
Thread ID:
00096615
Message ID:
00096615
Views:
44
It would seem that in FoxPro 2.x the best way to index a table
on a DATE field was to index on DTOS(Fieldname) as that
created a character based index which proved to be much faster
in operation than a date based index where, during comparison,
dates had in any case to be converted internally to characters by FoxPro.

My question is : does this still hold true in Visual FoxPro,
or is there an even better way to have date-based indices in
Visual FoxPro 5.

Note : I could of course run some experiments, but by posting this
question I am hoping someone else has already done the experiments.

Much Thanks.
Michel Creppy.
Next
Reply
Map
View

Click here to load this message in the networking platform