Update Async Topic Docs

[Carlton Gibson]

The ​Asynchronous support topic doc was written when we first introduced async support. It's outdated, and the warnings it gives are misleadingly negative. Time to refresh it.

The main problems are:

1. It strongly implies that Django's asynchronous story is unfinished. It's often linked to in blog posts. And it's totally misleading. The user API is essentially finished. From the PR: """Many parts of Django provide asynchronous APIs, including :ref:the ORM <async-queries>, the cache framework, authentication, sessions, mail, and signals. For other code, the :func:sync_to_async adapter is a low-cost bridge (see :ref:async_performance)."""

2. The performance warnings are severely outdated. sync_to_async/async_to_sync usage is in the order or microseconds with modern versions of Python. This plays directly into implementation considerations where we're constantly pulled towards duplicating whole code trees, on the mistaken assumption that sync_to_async usage (in particular) incurs a (relatively) massive performance hit.

3. It makes no mention of the remaining async difficulties — such as concurrent DB queries — which are not Django specific. In particular connection pooling is the appropriate lever to increase throughput, regardless of whether you're using Django, any other async orm, or raw connections by hand. (The current phrasing implies it's the ORM that's at fault here: it's not!)

The topic doc here is a big source of the negative narrative about Django's async story. It's time to correct that.

[Carlton Gibson]

​PR

[Carlton Gibson]

FWIW this has come up again today on comments on ann interview of Jeff’s from PyCon US. “when will the ORM be async?”

[Mykhailo Havelia]

related PR - ​https://github.com/django/django/pull/20949

[nessita <124304+nessita@…>]

In 2c5e4af3:

Fixed #37165 -- Updated Async Support topics doc.

Removed outdated warnings, and updated performance considerations to
reflect current realities.

Thanks to Mykhailo Havelia for the detailed review.

[Natalia <124304+nessita@…>]

In 11393f27:

[6.1.x] Fixed #37165 -- Updated Async Support topics doc.

Removed outdated warnings, and updated performance considerations to
reflect current realities.

Thanks to Mykhailo Havelia for the detailed review.

Backport of 2c5e4af3cccd88a7f0ea66a56aff1a49ad274681 from main.

[Natalia <124304+nessita@…>]

In a6cfda9:

[6.0.x] Fixed #37165 -- Updated Async Support topics doc.

Removed outdated warnings, and updated performance considerations to
reflect current realities.

Thanks to Mykhailo Havelia for the detailed review.

Backport of 2c5e4af3cccd88a7f0ea66a56aff1a49ad274681 from main.