We purchsed your DBF driver in 2006 and have been using successfully ever since , however recently we have been having some trouble with existing indexes.
What we have found is that if we do a large number of record insertions into a DBF then the DBF is updated fine, however the index is not updated until we restart the server. We have also noticed the the index 'last modified time' is also not updated until a server restart. What we have found is that if the server is not restarted for a few days eventually the index bacomes corrupt and not data is returned until a PACK and REINDEX command is run on the DBF.
Should we be using the 'REINDEX' SQL command after we inset data into the file or do index's get updated automatically after each record write?
Also, how does indexing work on SELECT queries on a DBF? If the query matches an existing index is that index used and what happens if an index is not found, is an index built on the fly for the purpose of the query?
Many thanks in advance for your help.
Kind REgards, Chris Kyte.
|
Maybe you should consider to order one-year free ugrade and support service at download page so that we can support you with the latest version. The main new features is listed at here
>Should we be using the 'REINDEX' SQL command after we inset data into the file
>or do index's get updated automatically after each record write?
Index file is automatically maintained.
>Also, how does indexing work on SELECT queries on a DBF? If the query matches an
>existing index is that index used
Yeah.
>and what happens if an index is not found, is an index built on the fly for
>the purpose of the query?
If delayedClose connection propery >60 , HXTT DBF will build automatic temporary index sometimes according to query requirement.
|