Administer > Manage WebSphere Commerce features > Marketing > Collaborative filtering > WebSphere Commerce Recommendation Engine powered by LikeMinds > Background LikeMinds utilities > Sifter utility
Configure the minimum number of transactions a user needs before becoming a mentor
The following setting specifies the minimum number of transactions a user must have before becoming a mentor. The sifter uses this setting if the Clickstream Engine is using that mentor set.
Procedure
- To configure the minimum number of transactions required as a percentage of the total number of items in the database:
- Stop the LikeMinds server inside the WebSphere Application Server.
- Use any database modification tool to enter the following SQL statement:
update lps_cfg set value='3%' where name='xactionMentor.min_mentor_xactions'
- Start the LikeMinds server inside the WebSphere Application Server.
- To configure the minimum number of transactions required as an absolute value (that is, without a percentage):
- Stop the LikeMinds server inside the WebSphere Application Server.
- Use any database modification tool to enter the following SQL statement:
update lps_cfg set value='3' where name='xactionMentor.min_mentor_xactions'
- Start the LikeMinds server inside the WebSphere Application Server.
Use the following guidelines for setting mentor_set_name.min_mentor_ratings:
Guidelines for Setting the Minimum Transactions
Total Number of Items in Database Suggested Setting < 1000 <= 40 1000-5000 <=100 5000-10,000 <= 500 10,000+ <= 1000