How many record can child table handle?

ERPNext
1

Just a thousand took some times to load, it may be time out if over 2 thousand records.
Is it possible to add pagination to child table (table grid)?

2

If you expect 1000 records on the child table, it is not designed for this use case. You are better off making it a full table, then adding a “Link” on the forum (see Email Group → Email Group Member)

Pagination in Child Tables is not considered, because we want to consider the document (parent + children as one unit).

3

How about Salary Structure, there is a table grid which store employee base salary. If i have ten thousand employees, is it possible to load? As I understand it’s child table as well, so it may need to separate the Salary Structure, right?

4

Maybe Salary Structure should be redesigned to handle 10k employees!

5

Is it in the ERPNext future development?

6

No idea. I guess we wait for someone with 10k employees to sponsor / contribute it! I am sure it will be a small fry for them :slight_smile:

1 Like
7

I think lazy load on table grid would help, no need to redesign.

8

Are you volunteering to build this? :slight_smile:

Thanks

Jay

9

For me this is the most logical approach.

10

That should be me… very soon :wink:

1 Like