asp.net读取access数据库，比asp还慢，

[fqingchu]

上代码，数据库中有几条记录还可以，但是数据库中有几百条记录时，就变得很慢，还不如asp的速度快。请高手给解答一下。


private bool Check(string username, string xh)
{
bool boolReturnValue = false;
String OleDbConnectiong = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=";
OleDbConnectiong +=Server.MapPath("1111.mdb");
OleDbConnection Connection = new OleDbConnection(OleDbConnectiong);
String strSQL = "select * from xh where username='" + username + "'and xh='" + xh + "'";
OleDbCommand command = new OleDbCommand(strSQL, Connection);
Connection.Open();
OleDbDataReader Dr = command.ExecuteReader();
while (Dr.Read())
{
if ((username == Dr["username"].ToString()) & (xh == Dr["xh"].ToString()))
{
boolReturnValue = true;
}
}
Dr.Close();
return boolReturnValue;
}
}

[ayanamireizero]

while (Dr.Read()) { if ((username == Dr["username"].ToString()) & (xh == Dr["xh"].ToString())) { boolReturnValue = true; } } 这里,你都已经在sql里写了where username='" + username + "'and xh='" + xh + "'" 为啥还去做遍历... 直接i if(dr.read()) boolReturnValue = true; 或者直接select count(*) as count from xh where username='" + username + "'and xh='" + xh + "'" if(dr(0)>0) boolReturnValue = true; 不就好了 另外,读access肯定比读sql慢了...

[devmiao]

String strSQL = "select count(*) from xh where username='" + username + "'and xh='" + xh + "'"; OleDbCommand command = new OleDbCommand(strSQL, Connection); return ((int)command.ExecuteScalar() > 0); 后面的代码都不要了

[sunny906]

xh是序号的意思吗？如果是，就把xh字段设置为主键看看；另外，如果只是检查数据表是否存在某些记录的话，就完全用不着用datareader

        private bool Check(string username, string xh)
        {
            bool boolReturnValue = false;
            String OleDbConnectiong = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=";
            OleDbConnectiong += Server.MapPath("1111.mdb");
            OleDbConnection Connection = new OleDbConnection(OleDbConnectiong);
            String strSQL = "select count(*) from xh where username='" + username + "'and xh='" + xh + "'";
            OleDbCommand command = new OleDbCommand(strSQL, Connection);
            Connection.Open();
            object o = command.ExecuteScalar();
            Connection.Close();
            boolReturnValue = Convert.ToInt32(o) == 0 ? false : true;
            return boolReturnValue;
        }

[宝_爸]

我觉得问题不在ls两位说的。lz试回来了没？

[宝_爸]

我觉得更大的可能性还是access 慢，估计用sql express会好点。

[myhope88]

access本来就比较慢吧

[水猿兵团五哥]

几百条数据还不至于慢