Обсуждение: Performance

Hi,

I currently us miniSql and have had problems with performance on a large
database. as an example I have a 30mg+ simple database each entry is date
stamped. When I request 1 years worth of data it take forever to return and
most of the time the browser times out. but when I request the data through
a CGI program using text files it is very quick. My question is does anyone
use postGres on databases that are the same or larger sizes than mine, and
could someone give me an idea of the performance.

in mSQL the query looks something like this :
-----------------

select * from table where date_stamp > 19970101 and date_stamp < 19980101

-----------------
table has 13 fields.

Thanks,

-G.