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

add_indexes.sql
CREATE INDEX idx_followers_status ON followers(status);
CREATE INDEX idx_followers_detected ON followers(detected_at);

Archive Old Data

archive_old_data.sql
-- 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

Memory Management