SplendidCRM was designed to perform equally well with thousands of records as it does with hundreds of thousands of records. However, if you database does contain hundreds of thousands of records, you will want to enable Custom Paging.
If you have any questions regarding this video, feel free to reply to this post.