insert into table SELECT c_ip,_date
FROM loginfo t WHERE (SELECT count(1)
FROM loginfo WHERE c_ip = t.c_ip AND id > t.id))<1这样呢?还有你索引是怎样建立的呢?
FROM loginfo t WHERE (SELECT count(1)
FROM loginfo WHERE c_ip = t.c_ip AND id > t.id))<1这样呢?还有你索引是怎样建立的呢?
FROM loginfo t where t.c_ip=(select top 1 loginfo.c_ip from loginfo where t._date=loginfo._date)
on loginfo(c_ip,[id])
SELECT c_ip, _date
FROM loginfo t
WHERE (NOT EXISTS
(SELECT 1
FROM loginfo
WHERE c_ip = t.c_ip AND id > t.id))
挺快的,但是在前面加上INSERT INTO cipinfo 后,在控制台执行,提示超时
且c_ip和id的值不能为空,如果有空,先将它们UPDATE成值""(字符型)或0(数字型)
可能是这个表有索引引起的,插入数据需要重建索引,所以慢,可以考虑分多次插入数据,每次数据量小些