I can't see how it changes from 10 to 10,000 items
You need to do a search of this forum "Woocommerce product updating CPU" or similar and discover all the horror stories. It's the combination of Woo and the AliWoo plugin
updating lots of products, especially ones with variations that
overload the CPU of many hosting accounts. Also, Woocommerce having only one database table for all product information makes it worse. The Original plugin spreads product info over several tables to "ease the load".
This Woocommerce single product table is also a cause of problems to others, not just Alidropship plugin users. There was a project at Github trying to develop a plugin to change the product table into multiple ones, but I think it's been abandoned now. This has all been common knowledge for quite some time. Woocommerce is also aware of it, so hopefully, they will do something about it in the future. But seeing as it's not a problem the the "majority" of people, it's probably not a high priority with them.
DB's but I have a travel website with 36k records and this is fine.
Those "records" are not being updated from a remote server (Aliexpress) every day. It's the product updating overloading the host's CPU that is
the problem for some. But all the solutions are here in the forum. The search box will reveal all.
I am not an expert but do know the rudimentary workings of the LAMP or LEMP stack.
Now you just need to brush up on search box use both here and on Google ...