I have not encountered any size limit for a workspace project but yes as the project gets bigger the performance and data exporting starts to get affected. If your project exceeds the maximum attachment size (eg 25 MB for gmail) it would not be received by the target. Some of the considerations you can look at are :
Cause or Recommendation
Number of breakdowns
If you are experiencing performance issues, you may need to reduce the number of breakdowns.
Size of date ranges
Smaller date ranges improve performance.
Number of users
Multiple users on the same project may cause performance issues.
200 rows is the maximum rows you can display in the table.
Analysis Workspace is not recommended for bulk data export. It is a visualization workspace creating dashboard-like analysis projects.