I use the sitemap generator for 30+ sites. For most it runs fine. But there are a few for which it runs and runs with no end in sight. For this site, paesanos1604.com, it ran for 3+ hours and was still running. It finds database records and indexes those. But when I looked at it there were over 21,000 Internal sitemap URLs. I know there were not 21,000 database records for that site.
Any idea what to do on a situation like this?