INSERT INTO `config` (`id`, `type`, `name`, `value`) VALUES
(1, 1, '', 'news'),
(2, 1, '', 'chinanews'),
(3, 1, '', 'mail'),
(4, 1, '', 'home'),
(5, 1, '', 'magazine'),
(6, 1, '', 'blog'),和
INSERT INTO `config` (`id`, `type`, `name`, `value`) VALUE(1, 1, '', 'news');INSERT INTO `config` (`id`, `type`, `name`, `value`) VALUE(1, 1, '', 'news');
INSERT INTO `config` (`id`, `type`, `name`, `value`) VALUE(1, 1, '', 'news');
INSERT INTO `config` (`id`, `type`, `name`, `value`) VALUE(1, 1, '', 'news');
INSERT INTO `config` (`id`, `type`, `name`, `value`) VALUE(1, 1, '', 'news');对比较频繁的数据,这两种的性能有多大差别?
(1, 1, '', 'news'),
(2, 1, '', 'chinanews'),
(3, 1, '', 'mail'),
(4, 1, '', 'home'),
(5, 1, '', 'magazine'),
(6, 1, '', 'blog'),和
INSERT INTO `config` (`id`, `type`, `name`, `value`) VALUE(1, 1, '', 'news');INSERT INTO `config` (`id`, `type`, `name`, `value`) VALUE(1, 1, '', 'news');
INSERT INTO `config` (`id`, `type`, `name`, `value`) VALUE(1, 1, '', 'news');
INSERT INTO `config` (`id`, `type`, `name`, `value`) VALUE(1, 1, '', 'news');
INSERT INTO `config` (`id`, `type`, `name`, `value`) VALUE(1, 1, '', 'news');对比较频繁的数据,这两种的性能有多大差别?
因为第一种方法一次性插入然后更新一次索引文件
而第二种方法在每执行一条Insert语句后都会更新一次索引文件,当数据量较大或比较频繁时这种方法就会非常的慢了.