The Noswhere indexer is currently handling hundreds of open connections with zero issues. It can very efficiently handle duplicates while still being able to import a lot of events.