The most common performance problems I've encountered in our projects are: 1) lack of indexes resulting in extensive table scans 2) I/O calls in a loop without

The most common performance problems I've encountered in our projects are: 1) lack of indexes resulting in extensive table scans 2) I/O calls in a loop without batching. I don't know if it counts as "I/O bottlenecks" or not.