Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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 Text(CSV)
Java 1.6
frank
2006-12-20 09:46:56.0
Hi,

I'm testing java 1.6 and have a problem with the HXTT CSV driver. Previously when doing a union all on big tables the memory consumption of the application was fairly stable (java 1.5.x). When using java 1.6 the memory jumps up to 1.5GB usage and the union all becomes very slow of course. Is there a version that can be used with java 1.6 that doesn't have this problem?

Thanks,
Frank
Re:Java 1.6
Frank
2006-12-20 13:12:35.0
Hi,

Seems after all that it's not really related to the java version. Once the files reach a certain size, all memory is consumed and things slow to a crawl. At least for a "union all" that does not seem necessary because it's merely an glorified append of files. Can you please have a look?

Thanks,
Frank
Re:Re:Java 1.6
HXTT Support
2006-12-20 18:02:38.0
> At least for a "union all" that does not seem necessary because it's merely
> an glorified append of files.
Yeah. Sometimes UNIION ALL will use where clause, ORDER BY clause and ResultSet.absolute() , so that HXTT does a simple design which maybe consume some large memory to do union all sometimes. Don't worry:)
Please show your frequent UNION ALL sql sample, and we will optimize it to avoid large memory issue. I guess that should be solved in 3 days:)
Re:Re:Re:Java 1.6
Frank
2006-12-21 14:14:16.0
Hi,

It's really a very simple query that is being performed. Apparently when the file size reaches a certain size things start to slow down.
Example:
select * from A
union all
select * from B

Frank
Re:Re:Re:Re:Java 1.6
HXTT Support
2007-01-01 07:05:31.0
Supported.

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