I have a query that inserts 47,599 records into a array like...
username,username,username,username,etc
The problem is going thru this many records it takes the page a very long time to load. Does anyone know of a quicker way to insert the records into the array? Listed below is the current code that is being used.
strSql = "SELECT M_NAME"
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE M_PMRECEIVE = 1"
strSql = strSql & " ORDER BY M_NAME Asc"
set rsName = my_Conn.Execute (strSql)
do while not rsName.eof
arrAllNames = arrAllNames & rsName("M_NAME")
rsName.moveNext
if not rsName.eof then
arrAllNames = arrAllNames & ","
end if
loop
rsName.close
set rsName = nothing
arrNames = split(arrAllNames, ",")<moved from="Help: General / Current Version (v3.4.xx)" by="Shaggy" />
Topic Locked
Posted - 26 April 2007 : 20:37:12
