From: | Chairudin Sentosa Harjo <chai(at)prima(dot)net(dot)id> |
---|---|
To: | pgsql-general <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Query time is too long for netscape |
Date: | 2000-01-25 02:04:30 |
Message-ID: | 388D04AE.795EE71E@prima.net.id |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I am using Postgresql 6.5.2 on SuSE 6.2, Pentium III 500, 128 MB RAM.
I have a database with 2 tables.
Table Detail has 500,000 records.
Table Customer has 1,000 records.
Both table has customer_number field.
The query looks like this:
select a.custnum, b.fullname, b.address, a.usages from
Detail a, Customer b
where a.custnum=b.custnum;
I wrote a CGI script with Pg module.
When I click 'submit' button on netscape, the postgresql starts
selecting. (I can see from 'ps aux').
However, after a few minutes, Netscape will say 'no data',
while postgresql is still selecting.
How do I overcome this problem?
How can I tell netscape not to expire the time, and keep waiting until
the data is sent to netscape?
I want netscape to wait for my data, no matter how long it takes to
'select'.
Is there a way to tell netscape, or do I have to change my script?
If I run from psql prompt, the query takes about 12 ~ 15 minutes to
finish.
Regards,
Chai
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2000-01-25 02:16:23 | Re: [GENERAL] max(oid) |
Previous Message | Charles Tassell | 2000-01-25 02:03:46 | Re: [GENERAL] System requirements |