I contacted SFMC tech support to ask about a limit on the number of rows that can be retrieved on a microsite landing page. First level support told me there isn't and there must be something wrong with the ampscript on my page which I don't believe is the case. He suggested I ask about it here.
So, if I use the code below to get the data, it gets about 300 rows and although it sometimes runs a little slowly, it does work:
LOOKUPROWS("My_Data_Extension", "Status", "M")
If I change it to the following where it would be pulling a couple thousand rows, it runs for a while and then throws me out to a 404 error page.
LOOKUPROWS("My_Data_Extension", "Status", "R")
My thought is that it is timing out pulling back all the data or that it is finding that it is too large of a data set. There are a fair number of fields in the DE and 2 of them are large text fields (think comment fields on contact forms). Is there any other way to get the data? I don't need the full row. Is there any way to specify returning only specific fields? Would that even help if I need to get back a couple thousand rows? Is there a limit to how many rows I can get back?