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