WIP: avoid zip and unzip to improve the speed of get_indexer
- [x] closes #23735 #34531 
- [ ] tests added / passed
- [x] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing.html#code-standards) for how to run them
- [x] improve the speed for get_index by avoiding some redundant zipping and unzipping
@qiuwei is this something you want to continue working on? > @qiuwei is this something you want to continue working on?

@datapythonista I realize there are a lot of implementations depending on the current `get_indexer` interface.
Changing this requires too much work for me at the moment.  

Close for now.