General information
Category:
COM/DCOM and OLE Automation
no, the file isn't indexed at all! it never has more than a few hundred records, and it is a shared file, so I don't see any performance reason to use an index, as the records are added and then only processed once.
also
<>
from hackers guide, a warning that the cdx may take longer to update than the table!
I use the go bottom/go top before locates because I have seen it make a difference in the past, to demonstrate, turn status ON from command window and open a table, have someone at another computer add records, your status bar won't show the new reccount(), issue a go top and usually it updates the status line instantly!
hackers guide suggests the header isn't updated right away, & I need to figure out where to enhance my settings to speed it up! I wonder if there is a better area here to discuss table buffering, but I suspect the answer is buried in foxisapi anyway!
have you had any similar problems where an index was helpful?
thx
mike
Previous
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