The database limits are:
500KB per record. There are no limits to number of fields.
No limit to the number of records.
10GB per site.
When displaying the results, you will do better by paging. Extremely large queries can take a long time, and trying to display large query result is also inefficient.