Query Speed!!!

Поиск
Список
Период
Сортировка
От Thirumoorthy Bhuvneswari
Тема Query Speed!!!
Дата
Msg-id 20020708122428.81652.qmail@web13605.mail.yahoo.com
обсуждение исходный текст
Ответы Re: Query Speed!!!  (nconway@klamath.dyndns.org (Neil Conway))
Список 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 по дате отправления:

Предыдущее
От: Vince Vielhaber
Дата:
Сообщение: Re: I am being interviewed by OReilly
Следующее
От: "frank_lupo"
Дата:
Сообщение: date problem and set style european