Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
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
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT DBF
Indexing ...
Chris Kyte
2010-06-09 02:01:00.0
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.0
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
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap