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
Slow results
David McCallum
2008-08-27 03:21:21.0
We have a table (urglocal) with over 8 million records.

There is a column "free" in this table.

There is also an "IDX" index created with the command "CREATE INDEX urgfree ON urglocal (free)"

When I execute the SQL command "SELECT TOP 1 recno() AS recnumber FROM urglocal WHERE free=true", this executes in under 10ms, but the code:

if (rs.next()) {
recNumber = rs.getLong("recnumber");
}

takes 100s of seconds to execute, we have tracked this down to the "if" line.

Is there anything we can do to speed this up, it's a real show stopper for our app.
Re:Slow results
HXTT Support
2008-08-27 03:36:05.0
What's your version of HXTT DBF?
Re:Slow results
HXTT Support
2008-08-27 03:44:20.0
1. How to know the detailed version information of HXTT DBF package?
1st way: "java com.hxtt.sql.dbf.DBFDriver" will print that information.
2nd way: check that MANIFEST.MF file in jar file.
Re:Re:Re:Slow results
David McCallum
2008-08-27 04:07:14.0
From MANIFEST.MF:

Manifest-Version: 1.0
Created-By: HXTT Version Robot
Main-Class: com.hxtt.sql.admin.Admin

Name: com/hxtt/sql/dbf/
Specification-Title: HXTT DBF JDBC 3.0 Package
Implementation-Title: com.hxtt.sql.dbf
Specification-Version: 3.1.046 on June 02, 2007
Specification-Vendor: Hongxin Technology & Trade Ltd.
Comment: JDBC 3.0 Package for Xbase database
Implementation-Version: 3.1.046 on June 02, 2007
Implementation-Vendor: Hongxin Technology & Trade Ltd.
Implementation-URL: http://www.hxtt.com/dbf.html

Name: com/hxtt/sql/admin/
Specification-Title: HXTT Database Admin
Implementation-Title: com.hxtt.sql.admin
Specification-Vendor: Hongxin Technology & Trade Ltd.
Specification-Version: 0.5 on June 02, 2007
Comment: HXTT Database Admin
Implementation-Version: 0.5 on June 02, 2007
Implementation-Vendor: Hongxin Technology & Trade Ltd.
Implementation-URL: http://www.hxtt.com/dbf/dbadmin.html

Re:Re:Re:Re:Slow results
HXTT Support
2008-08-27 04:21:23.0
>Specification-Version: 3.1.046 on June 02, 2007
Maybe the support for your package has expired. You can download the latest demo package from here to see whether your issue can recur. You can find Released Version Log athere.

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