I have a website that sells 100,000 items. The item data is stored in a mysql database. So, there aren't 100,000 html files on my site. Therefore, google can't see them. I read that the solution to this is to create site maps. I seem to have done that part correctly. On the google search console, now it says 100,000 items discovered. It's been that way for months and says 0 pages indexed. It doesn't say why. I read that the reason for this could be it's just too many items and it's overloading the system. I think it's referred to as "Crawl Budget." I didn't see a solution though. Should I be be submitting SOME site maps, wait for SOME pages to get indexed, then submit more. Seems rather tedious. And how much is too much to submit at once?
.html
files or served from a database has no bearing on Google's ability to crawl and index. Furthermore, site maps are not a solution for forcing Google to index pages. Does your site have 100,000 unique URLs that each return unique pages? If so, Google may simply be refusing to index your site for one of many reasons.