Postgres Pro
Downloads
Home   >   mailing lists

How to speed up the database query? - Mailing list pgsql-sql

From Abdul Wahab Dahalan
Subject How to speed up the database query?
Date
Msg-id 5076660.1130396616478.SLOX.WebMail.wwwrun@openx.mimos.my
Whole thread Raw
Responses Re: How to speed up the database query?  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: How to speed up the database query?  ("Christian Paul B. Cosinas" <cpc@cybees.com>)
Re: How to speed up the database query?  (Bruno Wolff III <bruno@wolff.to>)
Re: How to speed up the database query?  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-sql
Tree view 
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
upthe 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.

pgsql-sql by date:

Previous
From: "padmanabha konkodi"
Date:
Subject: handling money type
Next
From:
Date:
Subject: Complex Query - Data from 3 tables simultaneously