Share 'Why is Vlookup (in Excel) 1,000 times slower than hash tables in Python?'
I tried to essentially do a database join using vlookup in Excel, on two tables A and B that had just one field (email address) and 80,000 records each, to find which records in A were also present in B.
It took 10 minutes with Excel. With Python, using hash tables, it took less than 10 secs. I'm curious to know what would be the performance
with database systems (Oracle, Teradata, SQLserver, M…
You can share this discussion in two ways…
Share this link:
Send it with your computer's email program: Email this