by Liv » Wed Mar 20, 2013 1:05 am
Could be a sql timeout of some sort, that limits the number of records that can be pulled at a single time from a Select statement (how it pulls the data)
I'll keep this in mind if I make a future version and have some free time. Might be possible to pause the calls to the server, but I'm unfortunately swamped with mid-terms at the University right now to really get into it.
I'd keep the 7,000 URL setting, and I'll keep you posted in the future if I get a chance to update it.
It could be a memory issue too. I believe SQL will put the data called into memory, before it dumps it into the script, and once that's full then there's not much it can do.
In either case, I think the work around would be to have multiple sitemaps, it's just I've never had to deal with it personally, so I've never coded it (I think my largest database was 7-9000 topics).
Then again if you do have these rogue topics (that don't really exist in the database), a repair of that issue might solve both issues.
Best thing might be to do is find one of these topic numbers, and check in your SQL dashboard if the topics do actually exist with posts too. If not, I'm certain someone on PHPBB would be glad to write you a $15 code to clean that up.