The slow indexing times you are running into are tied to your hardware. Your current setup falls a bit below the recommended specifications, which is causing the bottleneck.
here are the recommended specs for a Sui fullnode (ref):
CPU: 8 physical cores / 16 vCPUs
RAM: 128 GB
Storage: 4 TB NVMe drive
Given your current hardware, you might want to evaluate how you plan to use this node so you can optimize your setup:
Full API Setup: If you need the complete fullnode API (like gRPC), you will likely need to upgrade your hardware to handle the heavy indexing load
Self-Serving (GraphQL): If this node is just for your own use, you can skip the heavy indexing on the node itself. Instead, you can run the GraphQL stack as a completely separate service. You would set up its own indexer pipelines and a PostgreSQL database (using the sui-indexer-alt-graphql service). In this setup, your fullnode isn’t the data source at all — it just acts as a backend for executing transactions.