maximum rows and fields

[eluser]Glen Swinfield[/eluser]
This wouldn't be something that CI would limit in any way.

Performance issues would be more to do with your php/server/db setup. In MySQL for example 4000 rows isn't that many - 100 fields seems like quite a lot though. If you want to know how well it will work - try it, and use the benchmark class to monitor performance.