| From: | Thirumoorthy Bhuvneswari <tbhuvneswari(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Query Speed!!! |
| Date: | 2002-07-08 12:24:28 |
| Message-ID: | 20020708122428.81652.qmail@web13605.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | frank_lupo | 2002-07-08 12:29:30 | date problem and set style european |
| Previous Message | Vince Vielhaber | 2002-07-08 12:22:02 | Re: I am being interviewed by OReilly |