Is there a limit to the number of instances for a sub-object?
I'd say no - and I've never heard of any - they're just records in a table(s).
The only limit is the size of your database. If the database is full, you cannot create any more instances.
Retrieving data ...