Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Nice order to create
Message
From
18/03/2016 17:05:39
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
18/03/2016 16:34:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01633318
Message ID:
01633383
Views:
59
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]
Previous
Reply
Map
View

Click here to load this message in the networking platform