Welsh Corgi (11/30/2015)
I'm looking at another table that is much worse:
Yes, the table is horrible.
Even by the naming you can tell it's made of several different tables.
Cannot be good.
But 2.4 million rows is not such a big deal.
Not sure about Excel, but Access would handle it well.
Can you post top 3 queries which cause biggest performance problems?
_____________
Code for TallyGenerator