pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: omid omoomi <oomoomi@hotmail.com>
To: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Performance tuning!!!
Date: Tue, 28 Dec 1999 00:41:01 PST
Message-ID: <19991228084101.49303.qmail@hotmail.com> (raw)

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




view thread (7+ messages)  latest in thread

Message-ID: <19991228084101.49303.qmail@hotmail.com>
Permalink:  ../19991228084101.49303.qmail@hotmail.com/
Also on:    postgresql.org/message-id/19991228084101.49303.qmail@hotmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: oomoomi@hotmail.com
  Subject: Re: [SQL] Performance tuning!!!
  In-Reply-To: <19991228084101.49303.qmail@hotmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox