Re: Memory and performance

Em 05 Apr 2001, Cedar Cox escreveu:

>To this I say, remember that you are using a database! I would split this

>into 3 tables (people, exams, answers). Then only the 'answers' table

>would contain 3M records. Should be a bit faster. You don't want to have

>to store the <person> and <exam> with each <answer>.

>

>(If this is what you are doing then ignore me. I don't take you for an

>idiot :)

Yeah... I'm doing this... (I'm not a idiot! :)))) I'm just asking if
exist any way to optimize PostgreSQL to handle a great quantity of tuples.
(I will try the 7.1. By the way... in the URI
http://www.postgresql.org/ftpsite/dev/ we found a RC2 version, but in the
URI ftp://ftp.postgresql.org/pub/dev/ don't!)

Hugs,

Edipo Elder

[edipoelder(at)ig(dot)com(dot)br]

_________________________________________________________
Oi! Voc quer um iG-mail gratuito?
Ento clique aqui: http://www.ig.com.br/paginas/assineigmail.html