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.
|
What's your version of HXTT DBF?
|
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.
|
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
|
>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.
|