Question
optimizing a embedded property within a page
Hi All,
We have few properties embedded within a single page, which we want to optimize. But we do not want to use the optimize tool (i.e. right click property and click on optimize for reporting) since we do not want this to be done by all developers also want to have a track of changes done, which will help in koving stuff to next env.
Thus we want to optimize these properties by running the SQL script by DBA. what are the steps if we want to do this manually and how do we get the sql.
I know for pagelist properties, its by creating index rules and index classes and exposing properties in that index table, but want to know what is the process for single page level properties?
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Hi Ashish,
Doing a column creation from backend DB is not a good idea as there would be issues with the class map, updates, column population issues etc.
It is strongly recommended to use Property optimization wizard tool which does the following.
1. Get all the inherited classes(can select in which class context property needs to be optimized)
2. Add's a new column in the corresponding table.
3. Perform automatic column population job in the background.
4. Logs two records in pr_changelog table for tracking purpose on who has initiated the optimization.
If you don't want all developers to do the property optimization, you can remove the privilege SchemaPropertyOptimization on access roles and have it only for particular sr. system architect's access roles.
Hope this helps!