Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Nice order to create
Message
De
18/03/2016 17:05:39
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
18/03/2016 16:34:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01633318
Message ID:
01633383
Vues:
57
It's for a cursor not a table, parameters will remain while the cursor exists. So there is some sense in minimizing the size, because I need do rebuild the whole index on every refresh

>even worse: you wouldhave to reindex the whole file each time one of the parameters changes. The beauty of setting the UDF as index is that it only recalculates changed fields index for that particular row - so do NOT make the function dependant on a single field! Pre-set numbers give you HUGE advantage here ;-))
>
>>MIN (240,max(count(sections))*tnLength)
>>
>>but you are right, 240 is good enough and possibly it is faster to have the long index then to calc the len and min over and over
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform