From: | "omid omoomi" <oomoomi(at)hotmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] Performance tuning!!! |
Date: | 1999-12-28 00:41:01 |
Message-ID: | 19991228084101.49303.qmail@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
I'm not sure but may be that's because, by using java, all your data process
(from a query statement ) is running on client side. I mean that's more
likely to be a file server architecture. If you make the query run on server
side ( ie, using cgi as php or perl ) and plan a 3 tier architecture then
you will have your time saved enough.
So I don't think tuning the database makes it much different.
Any other comments from the experts?
with regards
omid omoomi
>From: Baris ULU <ulu(at)bornova(dot)ege(dot)edu(dot)tr>
>To: pgsql-sql(at)postgreSQL(dot)org
>Subject: [SQL] Performance tuning!!!
>Date: Mon, 27 Dec 1999 13:38:58 +0200
>
> Hi,
> I am executing a query from Java and I wait for a long time to
>gather the results especially for large tables; but when I execute it
>from the psql prompt it gives me a quick result....Can anyone help me if
>I can find anything about the performance tuning about the
>Postgresql6.5.3? My base classes are the JBCL QueryDataSet class to
>execute the queries...I know this side of the question deals with the
>Blackdown users bu I gues that the problem is about the backend
>process..
>
>
>THANKS
>
>Baris ULU
>Computer Engineer
>
>
>************
>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
From | Date | Subject | |
---|---|---|---|
Next Message | 709394 | 1999-12-28 10:46:44 | Empty value for DATA field |
Previous Message | Baris ULU | 1999-12-27 11:38:58 | Performance tuning!!! |