I'm currently working with a WordPress developer for my site and we are attempting to create a WordPress post/page for every item in my database.
There is a search-bar on the homepage and when the user searches for an item they will be brought to a unique page for that item that will allow users to leave comments.
The problem is there are around 10,000 items in the database that need this. The developer is slightly unsure and suggest the use of a script to automatically generate a post or page for each item but he stressed it would decrease site performance.
Is there an easy way to automatically do this while also allowing WordPress style comments for each item?
As it currently stands:
There is one page with the database search bar that will display the info under the search bar once the item is selected. The problem with this is that you will only ever have one set of comments for every single item which I don't want.