MySQL，需要一些关于如何为包含大量页面的网站设置站点地图的建议吗？

At the moment I have a sitemap specified in google webmaster tools, which looks like this..

www.mydomain.com/sitemap.php?from=20000&max=10000

This shows 10,000 pages from record id 20,000

I have 80,000 pages and my site maps are slow.

I don't want to end up having lots of sitemaps with these paramaters (as only google knows about them). But the pages pump out too many pages from the database and are really slow.

Can someone advise me what will be both fast and comprehensive and available to all bots ?

• Set up a cron job which creates static sitemaps.
• Set it to run daily, hourly, or in whatever schedule you like.
• Serve the static files to search engines (no load on database, fast, etc.).
• Use an index file of sitemaps