I have an old netbook with an old AMD C60 processor and 768MB RAM (700MB actually, because of zswap) and it is amazing to see that is runs Ubuntu-MATE 22.04 quite reasonable.
See this post:
Lubuntu is not much lighter than Ubuntu-MATE and you need to go lightweight (low RAM usage) on a computer with less than 1GB.
For any 64-bit computer with less than 1GB RAM I would advice Bodhi-Linux
(that is the the E17 based Moksha desktop on top of an ubuntu base)
For any 32-bit computer with even lower specs: Antix
No.
If you want faster and smaller than this, you should switch to debian.
And if you find that too bloated or too slow, try Arch-linux or even Gentoo: These distro's are more lightweight and give you much more control over the install ( especially Gentoo will give you the opportunity to make it as small and fast as you demand ) but it demands some more courage an willingness to learn than the average linux user is prepared to do.