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
