Karen J. Cooley

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.