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
Performance problem
Dewil Maxence
2005-04-06 00:00:00.0
Hi,

I have a performance issue when I try to connect to a dbf file located on a computer connected to our intranet via VPN.

When I execute my queries on a local copy of the dbf, the execution time is 16seconds. Next, via VPN it takes 20minutes (adsl - 33Ko/s average)!

(The remote dbf file is in SHARED mode.)

Can I do something to improve the performance?

Thx in advance for your response.
Re:Performance problem
HXTT Support
2005-04-06 00:00:00.0
Dear Dewil Maxence,

You shouldn't use share mode to visit remote data since you're using slow adsl line. You should use server/client mode. HXTT DBF supports port mapping and NAT route so that you can visit your data in intranet. Through VPN, you can visit a port of intranet host so that you should run a DBFServer on one host of your intranet. From Remote Access Questions of faq.html and dbadmin.html, you can know how to use com.hxtt.sql.admin.Admin to start a remote service. Any question or confusion? Just let us know.

With best regards,

Dai Wei
Re:Re:Performance problem
Dewil Maxence
2005-04-06 00:00:00.0
Thank you for your quick answer.

There is something I don't understand:
what is DBFServer? Does your package include the xBaseJ API?

I can't find the package "admin" and its class "Admin" in the jars on the download page, was it removed?
Re:Re:Re:Performance problem
HXTT Support
2005-04-06 00:00:00.0
Dear Dewil Maxence,

DBF supports three server/client modes(TCPServer, RMIServer, and FileProxy), which is including in DBF_JDBC30.jar, DBF_JDBC20.jar, and DBF_JDBC12.jar. It hasn't any relation with xBaseJ. DBFServer means it can works like a common database server to listening a port. For server side, java -cp yourdirectrory/DBF_JDBC30.jar com.hxtt.sql.admin.Admin" to start GUI manager, then add a remote service. For client side, any code needn't to modify, except for your jdbc url. For instance, the remote service url of server is jdbc:dbf://localhost:8029/d:/yourdata, and the client url can be jdbc:dbf://yourServerNameOrServerIP:8029/d:/yourdata.

With best regards,

Dai Wei
Re:Re:Re:Re:Performance problem
Dewil Maxence
2005-04-07 00:00:00.0
"com.hxtt.sql.admin.Admin"
Oops, I was looking in an old package (2004).

It is more clear for me now, I will try that way.

Thank you.
Re:Performance problem
Dewil Maxence
2005-04-13 00:00:00.0
Hi,

is it a way to programmatically start a dbf server instead of permanently running the GUI Admin app (for example, a windows service or an app in Tomcat)?

Thx.

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