CREATE TABLE `ky_number_section` (
`序号` int(11) default NULL,
`号段` varchar(50) default NULL,
`归属` varchar(50) default NULL,
`运营商` varchar(50) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk;INSERT INTO `ky_number_section` (`序号`,`号段`,`归属`,`运营商`) VALUES
(1,'1368314','北京市',NULL),
(2,'1370102','北京市',NULL),
(3,'1368323','北京市',NULL),
(4,'1368322','北京市',NULL),
(5,'1368321','北京市',NULL),
....
....
....
上面这个表17万条数据 用source 命令导入用了10秒左右
下面这个表35万条数据为什么要4个小时左右呢?
CREATE TABLE TIPA_ADDRESS (
ID INT,
IP1 INT,
IP2 INT,
COUNTRY VARCHAR(80),
CITY VARCHAR(10)
)
insert into TIPA_ADDRESS (ID, IP1, IP2, COUNTRY, CITY)
values (80197, 1046585344, 1046609919, '挪威 ', null);
insert into TIPA_ADDRESS (ID, IP1, IP2, COUNTRY, CITY)
values (80198, 1046609920, 1046675455, '意大利 ', null);
insert into TIPA_ADDRESS (ID, IP1, IP2, COUNTRY, CITY)
values (80199, 1046675456, 1046708223, '西班牙 ', null);
...
...
...
`序号` int(11) default NULL,
`号段` varchar(50) default NULL,
`归属` varchar(50) default NULL,
`运营商` varchar(50) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk;INSERT INTO `ky_number_section` (`序号`,`号段`,`归属`,`运营商`) VALUES
(1,'1368314','北京市',NULL),
(2,'1370102','北京市',NULL),
(3,'1368323','北京市',NULL),
(4,'1368322','北京市',NULL),
(5,'1368321','北京市',NULL),
....
....
....
上面这个表17万条数据 用source 命令导入用了10秒左右
下面这个表35万条数据为什么要4个小时左右呢?
CREATE TABLE TIPA_ADDRESS (
ID INT,
IP1 INT,
IP2 INT,
COUNTRY VARCHAR(80),
CITY VARCHAR(10)
)
insert into TIPA_ADDRESS (ID, IP1, IP2, COUNTRY, CITY)
values (80197, 1046585344, 1046609919, '挪威 ', null);
insert into TIPA_ADDRESS (ID, IP1, IP2, COUNTRY, CITY)
values (80198, 1046609920, 1046675455, '意大利 ', null);
insert into TIPA_ADDRESS (ID, IP1, IP2, COUNTRY, CITY)
values (80199, 1046675456, 1046708223, '西班牙 ', null);
...
...
...
除了那个还有没有其他问题?