I’ve worked for a massive corporation in which they had 300mb+ excel files they bought high specs computers just to have them load fast enough and searching would take 3 to 5 minutes we suggested that they’d try moving it to Microsoft access and the query became instant, I can’t imagine the hours wasted waiting for the queries to run
The amount of massive excel sheets I’ve seen in various departments, when I was working as an office IT was ridiculous.
Some people had to wait for 30 seconds with every minor change and that was “normal”.
Excel != Database
I’ve worked for a massive corporation in which they had 300mb+ excel files they bought high specs computers just to have them load fast enough and searching would take 3 to 5 minutes we suggested that they’d try moving it to Microsoft access and the query became instant, I can’t imagine the hours wasted waiting for the queries to run
Jesus guys just hire a dba and go to SQL already.