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.
|
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
|
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?
|
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
|
"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.
|
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.
|
Main
webmaster@hxtt.com