We're probably safe with the 10 MB/50,000 URL limits specified by google using this strategy, but I believe this can and will exceed the 1 MB memcache limit in production. I don't think using a textfield in mysql is a good idea either, b/c that has a 4 MB limit. We could break the data up into 1 MB chunks and still store in memcache, or do a per-locale sitemap and turn the main sitemap into an index, but to me it seems like writing the sitemap to the filesystem and letting apache serve it probably makes the most sense. Rather than getting IT to add a cron job to keep this large chunk of data in memory for fast access, how about we call the management command during a production push on the admin node which writes the sitemap to the media directory, and then let the normal file replication process push it out to the web heads?