Good morning, I have a question I have a dataset collection and I would like to know how many allowed records can be entered into said collection if there is a maximum number
In theory, the amount is limitless. But, depending on row size, around 100.000/150.000 queries on non-indexed fields will become slow, sometimes hit a time out. If this is the case, you can Wix Support to put an index on certain fields.
Queries will still have a max page size of 1000, so for 100.000 rows, you will need to retrieve 100 times a new page with a max of 1000 rows. You cannot retrieve 100.000 in 1 go, that would become very slow and probably run out of memory to store on client.
Well, basically it would be a login with approximately 2000 records, there would be no problem then right?
@riveraanuar22 Right. 2000 is peanuts.