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@bornova.ege.edu.tr>
>To: pgsql-sql@postgreSQL.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