![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
The database, it is gefuckt
2017-Sep-08, Friday 08:54
I've gotten a lot of use of that icon since March.
Yesterday, for the first time since the new database switchover, I got a time-sensitive project. With the old software, these were easy--everything came together in a single file and it was loaded in, I went through it one by one, and signed off in our project-tracking software when it was done. Now, because there's no way to put records in sets since they all get mixed into a giant slurry and pulled out at random, I'm using an Excel spreadsheet, going down the list and manually searching for each record so I can check it. Click search. Click the search box. Tab over to the spreadsheet. Click the cell with the ID. Tab back to the browser. Paste the ID. Click the result. Click the appropriate tab. Click the button to investigate further. Click click click click. Keyboard shortcuts? Why would anyone want those?
Behold the glorious march of technology.
My annoyance does not entirely come from how it now takes 15 clicks to do something that I used to be able to do entirely on the keyboard in one-tenth the time, though. We've been having database problems the whole week, with me constantly emailing back and forth with support and them having to restart services over and over. Eventually the constant problems got escalated, and they're planning to completely rebuild the database over the weekend. But not soon enough, because not half an hour after I got a time-sensitive project, it completely broke and it was impossible for me to do anything. I just kept getting proxy errors over and over again and support said they'd have to do several hours' work reorganizing before I would be able to use it again. Since it was close to the end of the day, there wasn't much to do other than say okay, let them put the magic smoke back into the database, and go home myself. But we spent two years' time and millions of dollars and this is the result?
It seems to work now, though I get a 404 error on a good portion of resolutions. But I think they're taking, so I guess it works out?
Edit: Yaaay, now it's broken again!
Yesterday, for the first time since the new database switchover, I got a time-sensitive project. With the old software, these were easy--everything came together in a single file and it was loaded in, I went through it one by one, and signed off in our project-tracking software when it was done. Now, because there's no way to put records in sets since they all get mixed into a giant slurry and pulled out at random, I'm using an Excel spreadsheet, going down the list and manually searching for each record so I can check it. Click search. Click the search box. Tab over to the spreadsheet. Click the cell with the ID. Tab back to the browser. Paste the ID. Click the result. Click the appropriate tab. Click the button to investigate further. Click click click click. Keyboard shortcuts? Why would anyone want those?
Behold the glorious march of technology.
My annoyance does not entirely come from how it now takes 15 clicks to do something that I used to be able to do entirely on the keyboard in one-tenth the time, though. We've been having database problems the whole week, with me constantly emailing back and forth with support and them having to restart services over and over. Eventually the constant problems got escalated, and they're planning to completely rebuild the database over the weekend. But not soon enough, because not half an hour after I got a time-sensitive project, it completely broke and it was impossible for me to do anything. I just kept getting proxy errors over and over again and support said they'd have to do several hours' work reorganizing before I would be able to use it again. Since it was close to the end of the day, there wasn't much to do other than say okay, let them put the magic smoke back into the database, and go home myself. But we spent two years' time and millions of dollars and this is the result?
It seems to work now, though I get a 404 error on a good portion of resolutions. But I think they're taking, so I guess it works out?
Edit: Yaaay, now it's broken again!
