讨厌一下，如何添加、修改、删除，怎么写程序访问速度快

[LeanAsp]

sql="insert into class(id,username,hyfenlei)" & _
" values ('"& rsid(0) & _
"','"& trim(request.form("username")) & _
"','"& trim(request.form("hyfenlei")) & _ )"

set rs=connection.Execute(sql)

为第一种

sql="select * from class"
set rs=server.createobject("adodb.recordset")
rs.open sql,connection,1,3

rs.addnew
rs.fields("id")=rsid(0)
rs.fields("username")=trim(request.form("username"))
rs.fields("hyfenlei")=trim(request.form("hyfenlei"))

rs.update

为第二种

请问那种运行速度快