I have 100K products and still operate on a decent speed. you will not be querying 100K query on one page so the site should still operate pretty fast.
Remember if you are on shared server they might have a limit on the size of database. But even with 100K and large description I am still below the threshold.



