I'm using dynamic pages to deliver content based on categories and subcategories associated to each item in my data collection. I wanted to use those two fields to select content, but as makes sense, I am unable to use the same fields in the database for more than one page. That's fine but I see an issue when I try to create the link manually while creating the dynamic page. That process creates a new column in the collection and adds that manually created link to every item in the database. To this point that does not present a problem because additional filtering does get me only the content that I want, however I am concerned that this will cause a performance problem once I have a significant amount of data in the collection. Is anyone aware of this or have any suggestions?
top of page
Important forum update
This forum is migrating to one unified Wix community forum starting July 26th, and will be read-only during the process.
Wishlist Page is the official platform for requesting new features. You can vote, comment, and track the status of the requested features.
bottom of page
Hi Tal. Thanks for responding. So, my plan was to have a separate page with a different title and different ad for each category. The title and the ad is static (not being pulled from the data collection) because it has to be different for each "category,subcategory' of items pulled into the dynamic fields. In the database each item has a category and subcategory field. When I create any new dynamic page and create the link using those fields (category,subcategory) it does not allow me to do that because the prefix is the same and the db fields being used are the same as the very first page I created, which means that the link for every page would be the same. Can't happen right. That makes sense. So my solutions was to create pages not using the two fields so the links are all like this /reviews/furniture/office-chair or reviews/furniture/desks... as opposed to reviews/{category}/{subcategory}. When I created the very first page using the db fields it works perfectly only creating the link using exactly what was in the category and subcategory fields, but when i create any additional pages like this reviews/furniture/desks because I cant do this reviews/{category}/{subcategory}, a new column with links gets created in the db, but for every item in the database. That means that every item in the database becomes a possible item for every page until my {category} {subcategory} filters are applied. My concern is that this will cause the db to be very slow once there are thousands of items in there. Just trying to be proactive. At this point I think its better to use only one dynamic page, create a db collection with the titles and the ad html, and the subcategory value and use code to deliver the correct title and ad to the page. I hope that makes some sense.
Hi,
I'm not sure that I fully understand what is the issue you were referring.
You can use the same DB collection on multiple pages. Moreover, you can use reference fields in case you want to reference one collection.
If this is not what you were referring, please elaborate what is the scenario and what you would like to achieve.
Have a good day,
Tal.