I've been looking at the sorting stuff myself for an upcoming project and I'm wondering if it would be possible to update the sort order of the nodes using a single database query and Common Table Expressions (obviously it'd only work in SQL Server)? I'm still finding my way round the umbraco source, but it looks like the node sorter fires off at least one query per node, which as you say in your readme, could be quite slow for large numbers of nodes.
You'd lose a lot of the flexibility of your approach though, as you'd lose access to the api methods for each node, for the CTE thing I'm thinking of, you'd probably have to go on the parent id and sort everything underneath (although it might be possible to get the alias type checking working as well).
I'm still working a lot of this stuff out myself, so the idea of this package was mainly for more simple websites, and for me to get to grips with packages. I'd see people using something like autofolders if then had a more complex site.
Would definatley be interested to see what you come up with though.
Possible to use single database call?
Nice package!
I've been looking at the sorting stuff myself for an upcoming project and I'm wondering if it would be possible to update the sort order of the nodes using a single database query and Common Table Expressions (obviously it'd only work in SQL Server)? I'm still finding my way round the umbraco source, but it looks like the node sorter fires off at least one query per node, which as you say in your readme, could be quite slow for large numbers of nodes.
You'd lose a lot of the flexibility of your approach though, as you'd lose access to the api methods for each node, for the CTE thing I'm thinking of, you'd probably have to go on the parent id and sort everything underneath (although it might be possible to get the alias type checking working as well).
What do you think?
Hey Tim,
Sounds feasble.
I'm still working a lot of this stuff out myself, so the idea of this package was mainly for more simple websites, and for me to get to grips with packages. I'd see people using something like autofolders if then had a more complex site.
Would definatley be interested to see what you come up with though.
Matt
is working on a reply...