Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.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 Lab of Xi'an City (abbr, HXTT)

HXTT Paradox
Speeding up Paradox JDBC
Peter Ryan
2007-09-12 08:48:00
Hi,

I'm using your driver to connect via a Unix mount point to a Netware Server. The access is very slow.

Any tips on improving speed? RmiJDBC performs the same query in 13 seconds. With your setup it takes 1 min 20 sec.

Thanks,
Peter
Re:Speeding up Paradox JDBC
HXTT Support
2007-09-12 09:03:52

>RmiJDBC performs the same query in 13 seconds.
RmiJDBC is doing that through client-server mode.

>I'm using your driver to connect via a Unix mount point to a Netware Server.
>With your setup it takes 1 min 20 sec.
It seems that you're using network share file, which will process data on your Unix after read data from Netware server. You can try to copy your test data file from Netware to Unix host, and repeat your test only on Unix without network share. If your query speed is in seconds, we will discuss how to run HXTT Paradox on client-server mode, or check whether some network parameter resulted a slow network file share.

BTW, what's your sql?
Re:Speeding up Paradox JDBC
Peter Ryan
2007-09-12 09:16:13
Dear Hxtt Support,

Genius, pure genius. I should have thought of that. Well, the issue is not your driver. 3 seconds if the file is just on the machine.

The issue is the network parameter on the network file share. Since RmiJDBC works fine in client server mode. I'll see if my local folks can speed up the link. RmiJDBC is also slow with a bad link.

Thank you for the quick response,
Peter
Speeding up Paradox JDBC
Peter Ryan
2007-09-12 09:17:18
My native SQL is MySQL v5.0.

The big issue is being able to read and write to the old Paradox data in real time.

Thanks,
Peter
Re:Re:Re:Re:Speeding up Paradox JDBC
HXTT Support
2007-09-12 18:12:06
Maybe you can quicken network file access according to http://www.novell.com/documentation/nfsgynw/index.html?page=/documentation/nfsgynw/gwy_enu/data/anmo2hb.html . The preferable soulution is runnnig HXTT Paradox on client/server mode. You need to read Remote Access Questions, DBAdmin, and Run HXTT ParadoxServer as Windows Service or Linux(Solaris) Daemon.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap