iyiogrenci
New Member
I have a small adodb recordset I am trying to filter. This one is 6 records for our test customer. For some reason the filter is taking 2 seconds to complete, and I am doing this around 30 times on my asp page. Thus, making my page really slow to load. The other recordset filters on this page are running fast.I have tried setting different CursorLocations and CursorTypes..Can anyone help me determine why this filter is so slow?\[code\]rsAvgPrice.Filter = "CommodityID = 13 AND CropYear = '12'"\[/code\]