Hi, I've got a question about the use of indexes. I've a site running quite good. I've such features like polls and all that usual stuff. I take the poll tables as example. POLLS: idpoll bigint unsigned not null auto_increment primary key, dtquestion varchar(255) not null, ANSWERS FOR THE POLLS: idanswer smallint unsigned not null auto_increment primary key, fipoll bigint unsigned not null, dtanswer varchar(255), USER VOTES: fiuser bigint unsigned not null, fipoll bigint not null, fianswer smallint unsigned not null, Ok I indexed all the fields in every table. I know that there won't be a lot of polls in one year (about 24). The same for the answers and votes. As I indexed everything, I suppose mysql doesn't need to access the drive (of course selects only) since everything is stored in memory. Now my question is how do i calculate the memory usage. I've a lot off stuff like the polls which i indexed to gain speed and decrease disk seeks. Thanks in advance Regards, Patric de Waha --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php