So, let's say we had the necessary ram, cpu, and net to store a lot of records in a multi_index table. (100,000 to 1,000,000). Considering that a transaction in EOS has a max execution time (150 ms), we make individual transactions performing the following operations:
- Find a specific row by primary key.
- Looping all the records
Would any of this transactions fail for exceeding 150 ms?
What are the alternatives for storing and querying through a lot of records?