DbBenchmark.md
Search all books which the title starts with "Survival".
========================================
Use normal query
28.2 ms
Use stored procedure
227.9 ms
Use view
25.0 ms
========================================
Create index
10.44 s
========================================
Use normal query
3.3 ms
Use stored procedure
4.3 ms
Use view
3.3 ms
========================================
Drop index
7.610 s
SELECT * FROM bookshare.`bx-books` where `Book-Title` like "Survival%";
DELIMITER $$
CREATE PROCEDURE `search_by_title`(IN title VARCHAR(128))
BEGIN
SELECT * FROM bookshare.`bx-books` where `Book-Title` like title;
END$$
DELIMITER ;
CALL search_by_title("Survival%");
CREATE VIEW `search_title` AS SELECT * FROM bookshare.`bx-books` where `Book-Title` like "Survival%";
ALTER TABLE `bookshare`.`bx-books` ADD INDEX `title` (`Book-Title` ASC);