Scaling, accuracy and search quickness is very important for vector dbs. Do other general purpose databases scale as well as specialized ones? Because ideally

Scaling, accuracy and search quickness is very important for vector dbs. Do other general purpose databases scale as well as specialized ones? Because ideally they hold massive, well optimised indexes in their memory to be able to search quickly and not miss any vectors.