Performance
Optimize Polling
Scenario
Poll Interval
Fetch Limit
Low volume
120000 (2 min)
50
Medium volume
60000 (1 min)
100
High volume
30000 (30 sec)
200
Database Optimization
Add Indexes
CREATE INDEX idx_followers_status ON followers(status);
CREATE INDEX idx_followers_detected ON followers(detected_at);Archive Old Data
-- Move old launched followers to archive
INSERT INTO followers_archive SELECT * FROM followers
WHERE status = 'launched' AND launched_at < NOW() - INTERVAL '30 days';RPC Optimization
Use premium RPC providers for faster transactions:
Helius
QuickNode
Triton
