如何以可伸缩的方式仅向数据库添加唯一记录

I want to add only unique records into a database table. Is there any way to do this without having to do a select to see if the current record already exists, because that will get very time consuming as the table grows. I am open to all types of suggestions (if they exist).I want to add only unique records into a databa