How to Optimize ActiveRecord Queries with Large Data Sets in Rails 7?

I'm working with a large dataset in Rails 7 and some of my Active Record queries are getting slow. I've tried using .includes and .select, but performance still lags. What are the best practices for optimizing Active Record queries with millions of records? Also, is using This tool a better option in some cases?

Any tips or code examples would be appreciated!

I think when working with millions of records in Rails 7, you should combine .in_batches, .load_async, and explicitly specify .select to avoid loading unnecessary data. If queries are still slow, consider using raw SQL via find_by_sql or connection.execute to improve performance. Additionally, for more complex queries, tools like Sequel or ROM.rb might be better alternatives to ActiveRecord and Geometry Dash Spam Test.