this post was submitted on 09 Aug 2023
28 points (100.0% liked)
Memes
45558 readers
719 users here now
Rules:
- Be civil and nice.
- Try not to excessively repost, as a rule of thumb, wait at least 2 months to do it if you have to.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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.