I have an asp recordset that contains about 2300 rows and could climb to 4000 in the next couple of weeks. When I try to open the page I get "Buffer limit exceeded" even though I have increased that limit to 64MB. I will supply my code below. I have to believe that getting 4000 records should not be a problem if done correctly, right? I am including my query below. Please let me know where my query can be optimized.
As always, thanks!!!
Set rs = Server.CreateObject("ADODB.Recordset")
sql="SELECT p.ParticipantID, p.FirstName, p.LastName, rc.Bib, p.Gender, rc.Age, p.City, p.St, p.Phone, p.DOB, p.Email, rg.RaceID FROM "
sql = sql & "Participant p INNER JOIN PartReg rg ON p.ParticipantID = rg.ParticipantID JOIN PartRace rc "
sql = sql & "ON rc.ParticipantID = p.ParticipantID WHERE rc.RaceID IN (" & sEventRaces & ") " & sOrderBy
rs.Open sql, conn, 1, 2
Do While Not rs.EOF
PartArray(0, i) = rs(0).value
PartArray(1, i) = Replace(rs(2).Value, "''", "'") & ", " & Replace(rs(1).Value, "''", "'")
For j = 2 to 10
PartArray(j, i) = rs(j + 1).Value
i = i + 1
ReDim Preserve PartArray(10, i)