From: Christian Paul B. Cosinas <cpc@cybees.com>
To: 'Abdul Wahab Dahalan' <wahab@mimos.my>
To: pgsql-sql@postgresql.org
Subject: Re: How to speed up the database query?
Date: Thu, 27 Oct 2005 15:45:05 -0000
Message-ID: <001701c5db0d$66cc73e0$1e21100a@ghwk02002147> (raw)
In-Reply-To: <5076660.1130396616478.SLOX.WebMail.wwwrun@openx.mimos.my>
Of course as long as your table increases its records, the longer will take
your query.
I think what you want is to minimize the run time even though you have large
tables. You should fine tune your database server (which I am still looking
for the best configuration for my server haha). And get the most logical
queries. Avoid unnecessary queries.
-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Abdul Wahab Dahalan
Sent: Thursday, October 27, 2005 7:04 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] How to speed up the database query?
Hi everyone!
I'm looking for solution to speed up the database query, means that to get
resultset as quicker as we can.
For example if I've 700 records in the table it will take longer time
compared if I've only 20 records. How do we speed up the query?. Any query
technique that can be applied?.
Thus wild card query like : select * from tableA will cause query time
increased compare to say select a,b from tableA.
any help, prettymuch appreciated.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
I choose Polesoft Lockspam to fight spam, and you?
http://www.polesoft.com/refer.html
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: cpc@cybees.com, wahab@mimos.my
Subject: Re: How to speed up the database query?
In-Reply-To: <001701c5db0d$66cc73e0$1e21100a@ghwk02002147>
* 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