Viewing Limits?

Viewing Limits?

Is there a limit to the number of items that can appear on the Opps tab of a contact or company record or in the Opp List view? User claims there should be alot of Opps prior to the earliest appearance of 2/12/07 (several hundred since then) in any of the Opps views although no filtering appears to be applied that would be limiting access to earlier items. Thought there might be an SQL limit as to what can be viewed at-a-glance. If so, what is that limit? Otherwise, any thoughts on why the earlier items might not appear and/or how to get at them?