Primary what?
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.
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.