Message
From
23/01/2017 04:32:33
To
23/01/2017 03:16:30
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Calculated field
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2016
Database:
MS SQL Server
Application:
Desktop
Virtual environment:
Hyper-V
Miscellaneous
Thread ID:
01646855
Message ID:
01646952
Views:
41
>>persistent or static ?
>>then I update the background view's tables and VFP update the view cdx automatically ?
>
>whenever you requery the view, index update automatically
sure, but it writes the cdx fully, with 1 million records it is too slow.
>>then I update the background view's tables and VFP update the view cdx automatically ?
>
>whenever you requery the view, index update automatically
sure, but it writes the cdx fully, with 1 million records it is too slow.