Maximum number of records the table can manage

[bonsai]

※Paris version

I'm thinking of creating a lot of records in a table.

More than 1 million cases a day.

I think that if you do this for a few days, a table with a large number of records will be created, but I'm worried if you can delete tens of thousands of records or modify the contents at once.

Does anyone know how many records to create in a table as a best practice?

[Sai Kumar B]

Hi Author,

I don't believe there's a limitation on records creation. The only limit would be the space allotted to your database instance. If you create millions of records at a time you might run out of database space.

[subramanian · Accepted solution]

It all boils down to how we "manage" our data and ofcourse the database size. A few million records should not have a problem.

We have features like Auto Flush that help clean up data as necessary.

[Hitoshi Ozawa]

Technically, there doesn't seem to be a limit to the number of records in a table. According to the answer from ServiceNow employee in the following thread, however, there seems to be a contractual limitation of 4TB.

For your info, 4TB should be a contractual limit, not a physical/Technical limit. The current servers are having capacity ranging from 12 TB -21 TB. As such, the technical limit would the size of the servers. That said, there are other mechanisms such as gateways to move some of the approved tables to another database catalog to address the disk space issues. Please also note that the hardware capacity are subjected to changes are there may be new servers with larger disk space in the future.

https://community.servicenow.com/community?id=community_question&sys_id=f9271b101ba7a4100b8a9979b04b...

Performance of a table is going to change with number and logic of ACL, business rules, table relationship with other tables so there's no definite number for best performance on all tables.