Received: from smtp-31.ig.com.br (smtp-31.ig.com.br [200.226.132.181]) by postgresql.org (Postfix) with SMTP id 1190E4776F5 for ; Mon, 15 Apr 2002 13:38:08 -0400 (EDT) Received: (qmail 15211 invoked from network); 15 Apr 2002 17:38:02 -0000 Received: from unknown (HELO localhost) (200.226.132.30) by smtp-31.ig.com.br with SMTP; 15 Apr 2002 17:38:02 -0000 Date: Mon, 15 Apr 2002 14:38:05 -0300 To: pgsql-sql@postgresql.org From: Edipo Elder Fernandes de Melo Cc: X-Originating-IP: [200.225.157.84]200.19.175.3 X-Mailer: InMail by Insite - www.insite.com.br X-user: edipoelder@ig.com.br Subject: Large or Small tables? Message-Id: <20020415173808.1190E4776F5@postgresql.org> X-Archive-Number: 200204/189 X-Sequence-Number: 7453 Hi all, I'm developing a selective system for selection of students for a university. My system has tables for candidate, score, answers, exams, and others. The candidate table has about 40 columns, of that, 35 are candidate information (name, address, etc), 10 are for score, status, etc, and use 2 columns as primary key (a idCandidate and idSelection). The answers table has five columns: idSelection, idExam, idQuestion, idCandidate, and answer. Better explained: for each answer, it has a record (it's a lot of tuples - about 25000 candidates x 8 exams x 15 questions for exams = 3 milions!) The score table has idCandidate, idSelection, idExam, and score of each candidate and exam. Basicaly, to process the selection, I count how much questions the candidate got correct, make some calc, and find a score. My question is if is better have a unique candidate table with all information of a candidate, or broke the table in two tables (one to candidate information, and the other for score and status) for process of find score. Or better, Having a large table in a middle of a process, where i use only 10% of information on it, slow it down? Thanks for all, Edipo Elder [edipoelder@ig.com.br] _________________________________________________________________________ Você podia estar baixando sua musica predileta, enquanto lia esse e-mail. Não perca tempo, tenha acesso rápido a internet com o Super iG. http://registro.ig.com.br/superig