I don't use Photos, but from a technical perspektive, it is just a folder, not a single file (right click on it in finder and show content of package). So besides som database files with metadata, it is very much like asking how big a folder can be, which will depend on the filesystem. Of course there can be programatic limitation, inside the Photos app, but being a 64bit application I doubt it.