i've recently decided to create a website with wordpress.
My goal is to a visualize data stored in a MySQL database. Each id in the database should represent one page on the website. From what i've read a custom post type or a custom page template should do the trick.
But my biggest problem is that pretty much all tutorials i've read or watched so far explain how to create a page for each "product" manually. My database currently has ~44.000 entries and there are more to come on a weekly basis, so this can't be the right way.
Is there some way to dynamically create a page based of a template after the user searched for it?
There seems little point in creating a new post entry for each of your products if your table of products already has all of the information you wish to display.
Your best bet is to create a single page for example "Product" and then setup your own rewrite rule, using add_rewrite_rule, so that you can setup links such as
/product/some-product-alias. You would then need to perform a query on the product alias to lookup the product information from your product table and then display this on the template (either use page-product.php or create a template and assign this in the admin)
There's a little more information on setting up the redirects in this answer of mine.