g33kboi: (Default)
[personal profile] g33kboi
Update on the application situation...

Hello. My name is, Dianne and I am a database n00b. The reason the second application was locking up was because there wasn't an index on the field that was suddenly being used in several where clauses. So yeah, when you reference an unindexed field in a table with millions of records in it, it takes a really long time to execute and makes it look like the database isn't responding. Doh! Of course, said field should be a primary key because it is the only unique field in the entire table and as such would be indexed automatically, but that's a minor detail, right? After all, who needs primary keys and foreign keys to maintain relational integrity in a relational database? Not us. We're the government. Anyway, added an index. Problem solved. It only took all day to figure this out. Ugh!

Moving on to happier, more vacationy thoughts. I have rain boots and sunscreen now for the festival. One wouldn't ordinarily think those two things would go together, but this is Falcon Ridge. It's always sweltering hot and it always rains. Still need bug repellent that won't give me cancer as soon as I touch the package. Going to go down to the festival grounds early-ish tomorrow to check in as a volunteer and sign up for shifts as well as pitch my tent, then it's back to Albany for work at job #2 and one last night of sleep in a clean, dry bed before music and mud. :-)

My must see events at the festival...

Thursday

3 PM - Might try to catch Practical Advice on Staying Healthy on the Road on the family stage. The Famous Jane is a panelist. :-)
4:30 PM - Possibly Performance Skills Critique also on the Family Stage because Susan Werner is on that panel
5:15 PM - Ooo! Swing 101 & 102 at the Dance Stage! Totally there! Might check out other beginner level dance type stuff as well if I'm not otherwise occupied.

Friday

Surprisingly little that I must see or do on Friday. I want to catch Coyote Grace and Aiden James in the Emerging Artist Showcase on the Main Stage. They should be sometime in the second half, between 2 and 4:30.
5 PM - Living Planet (whatever that is) on the Workshop Stage because Girlyman is slated to perform
10:45 PM - Friday Night Summer's Eve Song Swap with Susan Werner, Janis Ian and other amazing performers on the Main Stage

Saturday

11:45 - Might try to catch Not Just Another Old Fashioned Love Song on the Workshop Stage because Pamela Means is on the panel.

2:10 PM - Susan Werner on the Main Stage!
4:30 - The Songs of Paul Simon on the Workshop Stage because it's the songs of Paul Simon. Duh. And Susan Werner is on the panel. :-)
7:30 - Pamela Means on the Main Stage
9:30 - Janis Ian on the Main Stage
10:30 - Girlyman on the Main Stage! Wish it were earlier, but being this late they will probably be extra funny and inappropriate.

Sunday

11 AM - Gospel Wake Up Call on the Main Stage because Girlyman is participating.
2:15 PM - Groovin on a Sunday Afternoon on the Workshop Stage because Girlyman is on the panel.

Date: 2009-07-22 07:27 am (UTC)
From: [identity profile] misslynx.livejournal.com
It took me a while to get in the habit of assigning primary keys, foreign keys and things like that when I first started doing database stuff too - there's a lot to keep track of at first! But eventually it becomes more or less instinctive, and the keys just kind of shape up automatically as you work out the database design.

But working with a database that large has got to be scary... At least I got to make most of my initial mistakes on smaller projects!

Date: 2009-07-22 02:39 pm (UTC)
From: [identity profile] lgbtech.livejournal.com
Yeah, if I had been the one to design this database, it would have primary and foreign keys and it wouldn't be the mess it is now. That's one of the first things I do when I design a db. Figure out what the unique key is going be and how the tables are related to each other. I usually do add additional indexes as well, but didn't think to check if this field was indexed, which was a rookie mistake. Oh well. Live and learn.

The data I'm working with is a colossal mess. I've been freaking out over the condition of it since I started working here. Legacy code (and data) is such a joy to work with. :-/

Profile

g33kboi: (Default)
g33kboi

October 2010

S M T W T F S
     12
3 456789
10111213141516
17181920212223
24252627282930
31      

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Sep. 20th, 2017 09:51 pm
Powered by Dreamwidth Studios