Query Speed!!! - Mailing list pgsql-general

From Thirumoorthy Bhuvneswari
Subject Query Speed!!!
Date
Msg-id 20020708122428.81652.qmail@web13605.mail.yahoo.com
Whole thread Raw
Responses Re: Query Speed!!!  (nconway@klamath.dyndns.org (Neil Conway))
List pgsql-general
hi,
I am using Postgresql-7.1.3 with RedHat Linux-7.1 and
JDBC. I am having an indexed table with nearly 3,000
records for a month. My machine is with 256 MB RAM,
600 MHz. I am having a report from the abovesaid
table, which displays 1 month's records at a stretch
using Swing components. If I run the query from the
hard-disk
it takes about 5 seconds to display all the 3,000
records. If I connect 3 nodes to it and run the query
from a node, it takes about 1.5 minutes. I don't know
where I am wrong. Please do reply. thanks.

bhuvana.

__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com



pgsql-general by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: I am being interviewed by OReilly
Next
From: "frank_lupo"
Date:
Subject: date problem and set style european