Vilket av dessa är snabbast?

	strSQL = "SELECT username, epost, presentation FROM userr WHERE userID=" & userID
	Set RecSet = Connect.Execute(strSQL)
			
	IF NOT RecSet.EOF THEN
		arrRecords = RecSet.GetRows
	End If
				
	RecSet.Close
	Set RecSet = Nothing
	Connect.Close
	Set Connect = Nothing

	username = arrRecords(0,0)
	epost = Server.HTMLEncode(arrRecords(1,0))
	presentation = arrRecords(2,0)

Eller

	strSQL = "SELECT username, epost, presentation FROM userr WHERE userID=" & userID
	Set RecSet = Connect.Execute(strSQL)
			
	IF NOT RecSet.EOF THEN
	username = RecSet("username")
	epost = RecSet("epost")
	presentation= RecSet("presentation")
	End If
				
	RecSet.Close
	Set RecSet = Nothing
	Connect.Close
	Set Connect = Nothing

Getrow tar väl mer prestanda eller?

------------------
Alltid lär man sig något nytt varje dag...

[Redigerat av Lukaspojken den 27 aug 2001]