为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。 【DM版本】:8 【操作系统】:麒麟 【CPU】:4核CPU 【问题描述】*:数据库里有一张定位数据表,大概10个字段左右,只有一个主键没有索引也没有分区,每天会通过定时任务拉取接口四百万行数据插入进去,任务刚开始时日志显示插入基本不耗时,现在任务已经执行一个月了,这张表里大概有1.5亿行数据了,现在每天任务基本插入就要花费几个小时。请问是为什么?因为数据量上来了吗还是别的原因,该怎么解决。
CREATE TABLE ODS_GNSS_HISTORY ( "ID" CHAR(36) DEFAULT SYS_GUID() NOT NULL, "DATASHARE_XH" INT, "VEHICLEGPSID" VARCHAR(64), "SERVERID" VARCHAR(20), "VEHICLENUM" VARCHAR(50), "PLATECOLOR" VARCHAR(10), "LONGITUDE" DOUBLE, "LATITUDE" DOUBLE, "SPEED" DOUBLE, "ALTITUDE" DOUBLE, "DIRECTION" DOUBLE, "RECORDTIME" DATETIME(6), "CREATETIME" DATETIME(6), "DRIVINGSPEED" DOUBLE, "TOTALMILEAGE" DOUBLE, "STATE" INT, "ALARM" INT, "XZQH_DM" VARCHAR(20), "XZQH_MC" VARCHAR(100), CONSTRAINT PK_GNSS_HISTORY_NEW PRIMARY KEY ("ID") ) 这是建表语句
CREATE TABLE ODS_GNSS_HISTORY (
"ID" CHAR(36) DEFAULT SYS_GUID() NOT NULL,
"DATASHARE_XH" INT,
"VEHICLEGPSID" VARCHAR(64),
"SERVERID" VARCHAR(20),
"VEHICLENUM" VARCHAR(50),
"PLATECOLOR" VARCHAR(10),
"LONGITUDE" DOUBLE,
"LATITUDE" DOUBLE,
"SPEED" DOUBLE,
"ALTITUDE" DOUBLE,
"DIRECTION" DOUBLE,
"RECORDTIME" DATETIME(6),
"CREATETIME" DATETIME(6),
"DRIVINGSPEED" DOUBLE,
"TOTALMILEAGE" DOUBLE,
"STATE" INT,
"ALARM" INT,
"XZQH_DM" VARCHAR(20),
"XZQH_MC" VARCHAR(100),
CONSTRAINT PK_GNSS_HISTORY_NEW PRIMARY KEY ("ID")
)
这是建表语句