SQlite查询执行表连接查询耗时过长,如下所示:
SELECT COUNT(Level.ControlStatus) FROM Inspections,Level,RoomData WHERE Level.LevelType = 14 AND ((Level.ID = RoomData.ID or Level.ID = RoomData.ExtraLevelID) AND Level.IsExtraLevel=RoomData.UseExtraLevel AND Level.InspectionUniqueID=RoomData.InspectionUniqueID) AND (Level.