As a developer and an analyst dealing with large data sets, having a limit is really annoying. But, that being said, having a limit is also beneficial when trying to bring all that data onto the screen. I find anymore than 100 visible rows tends to really slow the performance.
My recommendation would be to review your data structure and build efficient indexing using relational data.