Rajesh Kumar Mallah wrote:
what is the query ?
use LIMIT or a restricting where clause.
You could also use a cursor.
Joshua D. Drake
regds
mallah.
On 4/10/06, *soni de* < soni.de@xxxxxxxxx <mailto:soni.de@xxxxxxxxx>> wrote:
Hello,
I have difficulty in fetching the records from the database.
Database table contains more than 1 GB data.
For fetching the records it is taking more the 1 hour and that's why
it is slowing down the performance.
please provide some help regarding improving the performance and how
do I run query so that records will be fetched in a less time.
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
