STEEMSQL - Update 12 - About locks and performances
7 years ago by arcange (73)
$28.10
- Past Payouts $28.10
- - Author $21.76
- - Curators $6.34
122 votes
- + teamsteem: $5.158 (19%)
- + ausbitbank: $4.622 (20%)
- + msp3k: $3.218 (100%)
- + timcliff: $2.679 (76%)
- + paulag: $1.627 (100%)
- + czechglobalhosts: $1.511 (13%)
- + tarekadam: $1.199 (75%)
- + kevinwong: $1.163 (18%)
- + flameburst: $0.934 (100%)
- + geekgirl: $0.653 (100%)
- + arcange: $0.622 (100%)
- + buggedout: $0.539 (100%)
- + ace108: $0.518 (25%)
- + jedigeiss: $0.352 (100%)
- + drakos: $0.298 (100%)
- + joshbreslauer: $0.213 (30%)
- + patrice: $0.182 (100%)
- + vallesleoruther: $0.176 (100%)
- + netuoso: $0.164 (100%)
- + etcmike: $0.152 (10%)
- … and 102 more
Great work @arcange. I often wondered how it was possible to open a SQL server up to the world without it being killed by bad queries. SteemSQL is an invaluable resource and your VIEW solution seems sound so I hope it does the job. Thanks again.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Yeah, making a server public is kind of crazy thing.
I should have thought a bit before doing it.
Anyway, as I did, I now have to deal with ...
Funny (but exhausting) thing to do and learning a lot. So ... added value for everyone.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This kind of thing gives an opportunity to learn.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hey @arcange thanks buddy for the update and nice post as well.
Thanks again.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
full vote for this!
and thanks alot for hosting this, adding a witness vote as well!
Kind regards
Jan
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you so much for your support!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@rawdawg just voted for you as a witness. Good luck bro!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you. Really appreciated!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
just an FYI, we just got MVP michaelvenompaige on steemit. . .
He is a well known MMA fighter. . .like really well known. . . We should get him some Steemit gear. Is that something we would ask SteemInc for?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@ michaelvenompage
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@arcanage I voted for you. Thank you for your hard work on this awesome db for us. I know it is not easy and often thankless. I greatly appreciate your work!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great solution! Nicely done.
I got in the habit some time ago of always using nolock, but I only write very basic queries and now mostly use Power BI. So this will make it much better.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Phenomenal work. Although with the down times and crashes, some tables were missing data. Will that require a new full resynch or is it fixed?
This VIEW trick is awesome, I'll try it on my databases.
P.S. I was one of those lazies (well not lazy, but busy) who forgot to implement NOLOCK...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Are you Bad or Ugly? ;)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I am the Good.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Good boy! XD
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I hate it when people suck at queries...
Gotta do what ya gotta do with the database to make sure it continues to function!
Thanks for keeping the DB up and running!!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Just making sure I understand correctly... So now we will be able to use Power BI and query the Views and all will be good? Up voted for finding this solution!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Yes, you can now use PowerBI without worrying about the NOLOCK hint.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you for this update. And I understand the need to use views. I just wasn't aware that there was the ugly part. Full steem ahead!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I'm one of the "The Bad" here. I haven't had time to learn SQL queries and have been using Excel Power Query.
Thank you so much for providing this service! I use it daily to hunt down spam & scam.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
hay @patrice, I haven't forgotten you about that data, I was just fixing all my queries with sql before I could move on and do data for anyone. Give me a few days to catch up and I will be in touch
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I've been busy myself. Thanks!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks to my "view trick", everybody is now on "The Good" side ;)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I know i am one of the ones that has caused problems, i am now using sql no lock queries, so there should be no problems, I hope from my side. I also see the benefit in speed using sql queries and hope to help the bisteemit team get the hang of doing this too.
Keep up the good work and thank you for the update
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks @paulag for yor support. I know you were one putting the the server down, but you also did your best to try to correct the situation. And this is highly appreciated.
Let's have you labeled "The Good" ;)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thats a relief :-)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I like the "View to A Kill" fitting in this post :-)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit