By using this site, you agree to our Privacy Policy and our Terms of Use. Close

mrstickball said:


Spreadsheets are at 20-30MB and growing. The biggest issue is that I am doing a ton of match/indexes on tens of thousands of rows, dozens of times. My current laptop takes 1-2 minutes to process each iteration of the spreadsheet, which takes a long time.

When they get to that size, you're generally better off getting the data into a proper database like SQL Server Express or MySQL.  If you're doing a lot of aggregates, it might be worthwhile paying for the SQL Server Developer edition as that comes with the Business Intelligence suite allowing you to use Analysis and Integration services.