There's no hard-coded limit, but some functions will run more slowly with more songs. The largest database I've seen is about 1200 songs.
I would not separate songs into multiple databases if you want to view them all in the same show. Separate databases should generally only be used for separate bands that have little or no overlap in their repertoire.