I can't save any posts tonight. Cleared my browsing history but that didn't help.
Ancient Dragon
5,243
Achieved Level 70
Team Colleague
Featured Poster
Recommended Answers
Jump to PostI was making a change to the posts table, and that locked the entire posts table for a good 20 minutes. :(
Jump to PostI didn't realize they would be. I thought the database query was only going to take like 30 seconds to execute, and it ended up taking 20 minutes! I was just staring at the screen watching it do its thing and I kept saying, "Ok, any second now it's going …
All 5 Replies
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
I was making a change to the posts table, and that locked the entire posts table for a good 20 minutes. :(
Ancient Dragon
5,243
Achieved Level 70
Team Colleague
Featured Poster
Can you put up some sort of message telling us that the tables are locked so that we don't waste a lot of time trying to figure out what's wrong?
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
I didn't realize they would be. I thought the database query was only going to take like 30 seconds to execute, and it ended up taking 20 minutes! I was just staring at the screen watching it do its thing and I kept saying, "Ok, any second now it's going to finish ... Any second now ..."
Dani
4,084
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Also, I didn't realize the post was locked during the whole process. :(
Ancient Dragon
5,243
Achieved Level 70
Team Colleague
Featured Poster
Oh, I know that feeling -- been there and done that :)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.