I was trying to generate idealo feed in shopware 6 with 94000 product , it always generate a server timeout ,my best guess is the list is very big that is why it take time , I tried to increase my memory and execution time in PHP.ini , but it wont work
so now the Question is can we limit the number of product in Dynamic product Group in the Shopware admin?
I don't think you can limit the number of products found by a dynamic product group.
For bigger shops like yours I'd recommend to generate the feed via CLI by checking Generate via scheduler
in the configuration and create a cron job that runs the product-export:generate
console command.