Re: Partitioning
Rick,
This is the table that I am planning to create, for example. Making URI the primary key along with book_id.
As you recall, the SELECT is against URI field, which could return anywhere between say 5 to 1000 record. i.e.
SELECT score, start_cm, end_cm, text1, text2 FROM book_tbl WHERE uri='AB000010';
CREATE TABLE `mydb`.`book_tbl` (
`uri` VARCHAR(50) NOT NULL,
`book_id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`score` FLOAT NOT NULL,
`uri_cm` VARCHAR(45) NOT NULL,
`start_cm` VARCHAR(45) NOT NULL,
`end_cm` VARCHAR(45) NOT NULL,
`text1` VARCHAR(500) NOT NULL,
`text2` VARCHAR(500) NOT NULL,
PRIMARY KEY (`uri`, `book_id`)
)
ENGINE = InnoDB;