Karthik,
I'd highly recommend you be on v10 or up for Target DM usage. There have
been improvements. Prior to v9 you needed to specify attributes you wanted
to sort by in the Edit Project Settings dialogs. There were I believe 4-6
that you could sort by.
In v9 and up it is suggested to use Redundant DB structures to use one you'd
need to specify the db-structure ="{db structure}".
Anything you want to sort or constrain by should be part of an index on
those redundant DB structures. If you can put your constraints into the
redundant db structure itself so there are fewer items in the structures
they will perform better. So if you had say 3 ContentTypes then creating 3
redundant DB structures and selecting them dynamically would be higher
performing than your current query. There is of course a tipping point of
too much effort to setup vs performance return.
--
You received this message because you are subscribed to the Google Groups
"RedDot CMS Users" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/reddot-cms-users/-/FdMzUEIOEbsJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/reddot-cms-users?hl=en.
