Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT DBF
Indexing ...
Chris Kyte
2010-06-09 02:01:00
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.
Re:Indexing ...
HXTT Support
2010-06-09 02:25:48
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.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap