Fetching data from SmartTable

[rudreshkoranne]

Discord user ID

No response

Describe your question in detail.

Hey all,

I have a smart_table<address, Player> stored in my resource, where the Player struct is defined as:

Player {
    scores: simple_map<vector<String>, vector<vector<u8>>>,
    updated_at: u64,
    created_at: u64
}

With around 1 million entries in the smart_table, I need to retrieve all records that were updated within a specific time period. However, the view function is throwing an error. EXCEEDED_EXECUTION_LIMIT

Any ideas on how to resolve this?

What error, if any, are you getting?

No response

What have you tried or looked at? Or how can we reproduce the error?

No response

Which operating system are you using?

Windows

Which SDK or tool are you using? (if any)

TypeScript SDK

Describe your environment or tooling in detail

No response

[0x-j]

hi you probably want to use an offchain indexer in this case, and not store data in an onchain table.

you can look at an example indexer at https://github.com/0xaptosj/aptos-full-stack-template

[0x-j]

we also have a community member that made an indexer in ts https://github.com/lithdew/aptos-indexer