Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v6.0
  HXTT Cobol v3.0
  HXTT DBF v6.0
  Buy Now
  HXTT Excel v5.0
  HXTT Paradox v6.0
  HXTT Text(CSV) v6.0
  HXTT XML v2.0
Offshore Outsourcing
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
Heng Xing Tian Tai Ltd. of Beijing City (abbr, HXTT)

Performance problem
Dewil Maxence
2005-04-06 00:00:00.0

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
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

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)?


Search Key   Search by Last 50 Questions


Copyright © 1999-2017 Heng Xing Tian Tai Ltd. of Beijing City. | All Rights Reserved. | Privacy | Legal | Sitemap