From: | "DenBaguse MasRodjie" <roji(at)mail15(dot)com> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Query takes a long time |
Date: | 2003-10-07 07:54:53 |
Message-ID: | 004a01c38ca8$72ebdb80$1500a8c0@deskpro |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Thank you the query is sucessfull, but i have new problem. The query takes a long time(over 1 minute) for sub-select like below:
"select distinct t.bill_no, t.ref, t.bill_byr, c.name from artagih t, arcustomer c, arbill_lns where t.bill_no not in (select bill_no from arbill_lns) and t.cust_code=c.cust_code and t.d_r=arbill_lns.d_r and t.cust_code='CUST01' order by t.tanggal"
Is there something wrong with my query or do you have any suggestions?
If my query is correct, where is the problem? Is it in the postgre server or in ODBC?
Is there any OLE DB for Postgre, cause i'm using VB for my front-end application.
For comparison if i'm using MSDE for database server, it takes not more than 5 seconds for the same query with above.
With MySQL it takes over than 1 minute. I'm so confusing and stuck with this problem.
Thank you very much.
Roji
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-10-07 09:10:14 | Re: Query takes a long time |
Previous Message | Hiroshi Inoue | 2003-10-06 22:31:39 | Re: odbc eating parser error messages? |