Performance Audit for Hone

Rust Backend (hone-core, hone-server)

Database Performance (db.rs)

• N+1 Queries: Watch for loops that execute queries
• Missing Indexes: Ensure indexes on transactions(account_id), transactions(date), subscriptions(merchant)
• Connection Pooling: Using r2d2, verify pool size is appropriate
• Batch Operations: Prefer batch inserts over individual inserts in loops

// BAD - N+1 query pattern
for account in accounts {
    let txns = get_transactions_for_account(account.id)?; // Query per account!
}

// GOOD - Single query with JOIN or IN clause
let txns = get_all_transactions_for_accounts(&account_ids)?;