Check the number of order lines
You can run a SQL query to check how many order lines you have in your system.
Pre-enablement of WebSphere Commerce RVU Order Line Metrics
To find out the number of lines you have before WebSphere Commerce RVU Order Line Metrics is enabled, run this SQL query:select count(orderitems_id) from orderitems where orders_id in (select orders_id from orders
where status not in ('P', 'N', 'Q', 'T', 'W', 'Y', 'Z', 'NEW', 'RDY', 'CAN') and timeplaced is not null
and timeplaced > startDateTime and timeplaced < endDateTime);
startDateTime and endDateTime represent the time range of interest.
![WebSphere Commerce Version 7.0.0.9](../../com.ibm.commerce.base.doc/images/ngfp9.gif)
Enablement of WebSphere Commerce RVU Order Line Metrics
To find out the number of lines you have after WebSphere Commerce RVU Order Line Metrics is enabled, run this SQL query:select sum(linecount) from ordaudit where
timeplaced > startTime and timeplaced < endDateTime;
startDateTime and endDateTime represent the time range of interest.