I am working on a module where I need to save thousands or I guess millions of data (product'data from various e-commerce sites). So I am not sure of saving that data in a custom table by using custom entity or should I save that data in nodes?

As for searching, a user can use elastic or search\_api\_solr and use views for displaying the data, so is it better to use custom row or nodes to save that much of data?