waiting12345
Technical User
Hi, I was wondering what's the best way to do a loop through a list of items and display the number of reviews for each item. I was wondering if it was practical to do a count and then select the rest of the records and group each one or if it would be easier to actually have a field in the items table which keeps count of the number of reviews (incremented when new review made). This is taking into account speed as I wish for it to be as fast as possible so if it had to do a count each time across thousands of records I was wondering if this would make it drastically slower.
I'd appreciate your help. Thanks
I'd appreciate your help. Thanks