Huge data in my system is causing performance issues. So, I would like to delete 10000 records from Products table. Please let me know possible ways. Delete query with LIMIT is not working.
1
we can try below groovy script. Navigate to Console->scripting languages and toggle to commit mode.
import de.hybris.platform.servicelayer.search.FlexibleSearchQuery;
import de.hybris.platform.servicelayer.search.FlexibleSearchService;
import de.hybris.platform.servicelayer.search.SearchResult;
import com.google.common.collect.ImmutableMap;
import de.hybris.platform.servicelayer.session.SessionExecutionBody;
import de.hybris.platform.servicelayer.interceptor.impl.InterceptorExecutionPolicy;
import com.google.common.collect.ImmutableSet;
String query= "SELECT {PK} FROM {PRODUCT}";
FlexibleSearchQuery flexibleSearchQuery = new FlexibleSearchQuery(query);
flexibleSearchQuery.setCount(10000);
SearchResult searchResult = flexibleSearchService.search(flexibleSearchQuery);
modelService.removeAll(searchResult.getResult());