I'm getting massive discrepancies between the meta ItemCount (which is correct when viewing in sharepoint) and traversing the rows:
sp_list = site.lists['Support Database']
print(sp_list.meta['ItemCount'])
index = 1
for row in sp_list.rows:
index += 1
print(index)
In this instance, meta reports 11470. The index shows 97! There are no warnings or exceptions thrown. I'm about at my wits end.