Utterly Boring dot com

Database Rebuilds Suck

I'm going to be in Sunriver late tonight. We're completely restructuring our availability database here at the office for our reservation system and we have to change a pile of fields in the database, and rebuild the thing. And I have to rebuild after each of four different steps, and each rebuild takes about 40 minutes.

The office is buying us pizza today, that's for sure. Blogging back to normal tomorrow after I recover from this mess.

Posted by Jake on 11/07/04 @ 01:03 PM
Posted in Jake | 6 Comments | Permalink



6 Comments

Jon said on 11/07/04 @ 11:42 PM:
What database are you running? MS SQL Server?

Jake said on 11/08/04 @ 09:30 AM:
I wish. While that would still suck, it wouldn't suck as bad as what I'm running. I, honestly, don't know what DB system it's using (it's a DOS-based software), but I have a sneaky feeling it's using an old Turbo C/Borland database backend. Basically dumps an bunch of *.idx/*.fil files in the directory. It really sucks, and I would love to replace it with a SQL-compliant system (you should see the psycho-language the thing uses to generate reports).

Jon said on 11/08/04 @ 04:38 PM:
Yeesh... sounds like it could be a dbase format, or filemaker or something awful... that's disturbing. Though, the environmental system (heating & cooling) here at work--in a relatively new building--runs on a DOS-based system that requires--I kid you not--logging in via modem at 9600 baud....

Jake said on 11/08/04 @ 04:41 PM:
9600-baud...man, I haven't seen that kind of blistering speed since dialing into BBSes back in the day ;)



I actually got a sales pitch from a guy that wanted to replace our employee tracking system (we have employees that login from homes via the phones). His hardware? A 233mhz Pentium running DOS with a crapload of modems. And to operate it, I had to know a ton of phone commands, because you couldn't actually do anything on the console.

Jon said on 11/08/04 @ 11:20 PM:
What's worse, is that you can't have a DOS box open in Windows to use the damn thing... you have to escape out of Windows entirely to DOS mode! It's craptacular. I have a hard time accepting that in the year 2004 we are still reliant upon DOS software for, well, anything.


And, uhm, wow. Did you tell him 1996 called and wanted its technology back?

Jesse Thompson said on 11/10/04 @ 06:42 AM:
1996 hell, DOS control systems and 9600 baud modems sounds like late 80's at best :)

Post a comment












HTML Allowed: a href, b, br, p, strong, em, ul, li, blockquote




Comment Policy: Comments on older entries or comments containing a bunch of links are moderated automatically on this site to help fight comment spam. If you don't see your comment after submitting, it will appear on the site after it has been approved. We also reserve the right to remove your comment for any reason we see fit, but if you keep it remotely on topic, it'll stay. If you want a comment removed, e-mail us, but you'd better have a dang good reason or a truck load of money.

What are you doing down here? Don't you have something better to do? Like Go Back To The Top of the page, or even see who created this site? This site is © 2001 - 2012 by the Utterly Boring folks at UtterlyBoring.com. Steal my content, as I probably did, too, just link to my site or the original site. Batteries not included. One size fits all. Not for off-road use. Not for internal use. Do not taunt Happy Fun Ball.