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
Index and Query table size limits
Ralph Etienne
2010-10-20 13:13:34.0
Hi,

I have a pretty large table (about 140,000 records) and I and having a little trouble. I create an index on one of the columns and I am able to query but the issues is that this does not always work. It seems that ever now and then the index will be created but my connection will just stay there until it eventually times out. The same can be said about my query working sometimes and not others. Is there a limit to how big the DB can be when dealing with DBF v3.0? Could this be something I am doing wrong?

Thank you for your assistance.
Re:Index and Query table size limits
HXTT Support
2010-10-20 20:37:03.0
>Is there a limit to how big the DB can be when dealing with DBF v3.0?
4G.

Wheter you are using client-server mode? What's the value of your lockTimeout connection property? What's your create index sql, and select sql sample?
Re:Re:Index and Query table size limits
Ralph Etienne
2010-10-21 07:31:10.0
>Wheter you are using client-server mode? What's the value of your lockTimeout connection property? What's your create index sql, and select sql sample?

I have the service running from the jar file. In my java code I created a connection object.Maybe you could explain what you mean when you say client or server mode?

My create index query is:
CREATE INDEX abc ON Regpregn (Invno UNIQUE)

My Query is:
"SELECT DISTINCT on (Compcd+Shiptogeo+Invgrossam+Invtottax+Invno+Invdate+Invoiceid) Compcd, Shiptogeo, Invgrossam, Invtottax, Invno, Invdate, Invoiceid FROM Regpregn ORDER BY Invno ASC"

My lockTimeout is set to 300000 (3 minutes).

What is very weird is that the index will seem to be created but the query never comes back.

Thank you.
Re:Re:Re:Index and Query table size limits
Ralph Etienne
2010-10-21 07:43:39.0
Also, I get this error when it times out.

java.sql.SQLException: Timeout Interrupted Exception: beyond 30000 msecs to get result for a remote request, but that request should have been executed by remote server.
java.sql.SQLException: Timeout Interrupted Exception: beyond 30000 msecs to get result for a remote request, but that request should have been executed by remote server.
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.remote.a.a(Unknown Source)
at com.hxtt.sql.remote.l.a(Unknown Source)
at com.hxtt.sql.remote.u.do(Unknown Source)
at com.hxtt.sql.remote.y.a(Unknown Source)
at com.hxtt.sql.remote.y.executeQuery(Unknown Source)
Re:Re:Re:Re:Index and Query table size limits
HXTT Support
2010-10-21 07:51:01.0
>what you mean when you say client or server mode?
What's your jdbc url? If you access only local dat, you can use embedded mode.

>CREATE INDEX abc ON Regpregn (Invno UNIQUE)
>"SELECT DISTINCT on (Compcd+Shiptogeo+Invgrossam+Invtottax+Invno+Invdate+Invoiceid) Compcd, Shiptogeo, Invgrossam, Invtottax, Invno, Invdate, Invoiceid FROM Regpregn ORDER BY Invno ASC"
That index can not help you to distinct your sql sample. If can quicken the following sql:
SELECT DISTINCT on (Invno) Compcd, Shiptogeo, Invgrossam, Invtottax, Invno, Invdate, Invoiceid FROM Regpregn
Re:Re:Re:Re:Re:Index and Query table size limits
Ralph Etienne
2010-10-21 10:00:59.0
I started running in client mode and that seems to have resolved the issue. I still don't know why it would freeze in server mode.

Thank you very much for your help support.
Re:Re:Re:Re:Re:Re:Index and Query table size limits
HXTT Support
2010-10-21 17:20:53.0
>I still don't know why it would freeze in server mode.
Because client/server mode will limit long time operation. Embedded mode allows to wait the query result.

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