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
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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 Paradox
Speeding up Paradox JDBC
Peter Ryan
2007-09-12 08:48:00.0
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.0

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

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