优化对未知数据库的查询

鐿紓

第三方应用程序为每个项目创建一个数据库。所有数据库都有相同的表和结构。新项目可以随时添加，所以我不能使用任何 EF 架构。
我现在要做的是：
[code] private IEnumerable getListRespondentWithStatuts(string db) return query("select * from " db ".dbo.respondent"); } private List query(string sqlQuery) using (var sqlConx = new SqlConnection(Settings.Default.ConnectionString)) sqlConx.Open()；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；var cmd = new SqlCommand(sqlQuery,sqlConx); return transformReaderIntoRespondentList(cmd.ExecuteReader()); } } private List transformReaderIntoRespondentList(SqlDataReader sqlDataReader) var listeDesRépondants = new List()；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；while (sqlDataReader.Read()) var respondent = new Respondent CodeRépondant = (string)sqlDataReader["ResRespondent"], IsActive = (bool?)sqlDataReader["ResActive"], CodeRésultat = (string)sqlDataReader["ResCodeResult"], Téléphone = (string)sqlDataReader["Resphone"], IsUnContactFinal = (bool?)sqlDataReader["ResCompleted"] listeDesRépondants.Add(respondent); return listeDesRépondants; code]这项工作很正常，但速度很慢（每分钟记录2万条）。你应该提示什么策略应该更快吗？相关信息真的很慢transformReaderIntoRespondentList方法
谢谢！！

解决方案:

优化对未知数据库的查询

鐿紓 LV1