Loading and fetching data beyond limit into CRM

Initially, I successfully posted data to a customized module in SuiteCRM and received confirmation of the successful post. However, after reaching a certain limit, I encountered difficulties retrieving the data directly from that module. Instead, I established a relationship with another custom module, and I’m able to obtain the posted data using the relationship ID. What could be the reason behind this behavior?

DB software and version?
OS and OS version?
Suite 8 version?
Quick Repair Rebuild results at end showing commands must run?
Error log fatal and error?

also, what is this limit? Is it 10.000? 10 million?

DB software and version? MySQL, version 8.0
OS and OS version? Microsoft Windows 11 Home Single Language and 10.0.22631 N/A Build 22631
Suite 8 version? 8.4.1
Quick Repair Rebuild results at end showing commands must run? yeah
Error log fatal and error ? no error in the error log

The limit is around 130-140

Do you mean 130 custom fields (extra columns in database), or 130 records (rows in the database)?

Quick Repair Rebuild results at end showing commands must run? yeah

What are the commands that it shows at the end of the QRR results?

PHP version?

WAMP or XAMPP?