HPL Problem

Posted in 1999

Marichamy, Udaykumar — Tue, 10 Aug 1999 08:53:31 -0500 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BEE337.BB673310 Content-Type: text/plain I have had mixed feelings with HPL. It works fine with one table, loading 700,000-800,000 rows in 2 minutes. With another table, it just hangs. Doing a ps|grep load does not list any load processes other than the onpload GUI (motif) interface. Both tables have no indexes. Platform: IDS 7.31 UC2, AIX 4.3 X-server from MicroImages on Windows NT Any ideas/suggestions are welcome. Uday Marichamy ------ =_NextPart_001_01BEE337.BB673310 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3DUS-ASCII"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.1960.3"> <TITLE>HPL Problem</TITLE> </HEAD> <BODY> I have had mixed feelings with HPL. It works fine with one table, loading 700,000-800,000 = rows in 2 minutes. With another table, it just hangs. Doing a ps|grep = load does not list any load processes other than the onpload GUI = (motif) interface. Both tables have no indexes. Platform: IDS 7.31 UC2, AIX 4.3           = X-server from MicroImages on Windows NT Any ideas/suggestions are welcome. Uday Marichamy </BODY> </HTML> ------ =_NextPart_001_01BEE337.BB673310--