I
make a custom table for each attribute with relevant relational tables and then pull/push the data with the umbraco.BusinessLogic.Application.SqlHelper() class.
or
I
use a single documenttype
with template to create thousands of child documents each containing
an item record with all the related content via datafields.
What
is the way to go? I think the second method would create to many nodes and slow
the system down?
Using Umbraco 4.5.2 for searching and building large database
I need pointing in the right direction if i was to create something like www.bbc.co.uk/gardening/plants/plant_finder/ in Umbraco.
As i see it I have two choices:
I make a custom table for each attribute with relevant relational tables and then pull/push the data with the umbraco.BusinessLogic.Application.SqlHelper() class.
or
I use a single documenttype with template to create thousands of child documents each containing an item record with all the related content via datafields.
What is the way to go? I think the second method would create to many nodes and slow the system down?
Thanks
Go with custom tables and have a look at Examine to index and search with your custom datasource
My .02 cents
Cheers,
/Dirk
is working on a reply...