How large a table can be kept in Jira using the grid

The add-on use native database tables, so the limits are imposed by the underlying database configuration. In most cases it's almost limitless (given available disk space).

We do have a performance test-case where a single issue has 100000 rows, and a dropdown list 6000 entries.