General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I've created a lookup cursor using a VIEW composed of a UNION but when you first open it, it's too slow. It's a simple union - it's just the vast number of records it's adding creating the slowness (800,000).
>
>Since VFP tables are so much faster, I need to use a table instead. To do that, I need a way to detect when the underlying tables have changed so I can update this lookup table when it's out of date. I'm thinking a RECCOUNT() might be the way to go, or perhaps the file date of the table, or FSIZE(), or the last PK used in the table.
>
>I'm wondering it there's some low-level info in the header of the DBF that I might be able to use...
>
>Any advice?
add timestamps with an index on it (and flag instead of deleting)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only