Received: from hotmail.com (law-f15.hotmail.com [209.185.131.78]) by hub.org (8.9.3/8.9.3) with SMTP id DAA37412 for ; Tue, 28 Dec 1999 03:41:32 -0500 (EST) (envelope-from oomoomi@hotmail.com) Received: (qmail 49304 invoked by uid 0); 28 Dec 1999 08:41:01 -0000 Message-ID: <19991228084101.49303.qmail@hotmail.com> Received: from 195.200.226.110 by www.hotmail.com with HTTP; Tue, 28 Dec 1999 00:41:01 PST X-Originating-IP: [195.200.226.110] From: "omid omoomi" To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Performance tuning!!! Date: Tue, 28 Dec 1999 00:41:01 PST Mime-Version: 1.0 Content-Type: text/plain; format=flowed 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 >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