Hmmm, I am running Windows and none of the example queries I provide take more than 20-30 seconds max to run for me. Not sure why they would be running slower for you, but sometimes the database itself can be bogged down by too many queries. Sometimes people do stupid things like run a query that returns EVERY post and comment on Steemit (60+ gigs!), which of course locks up the database... Stay tuned for part two of this tutorial series, which should come out tonight! Good luck!
You are viewing a single comment's thread from:
I tried to run the query with specific tags and even as I am writing this, the query is still loading. I'll just see what I can do with proper internet connection and maybe wait when there's not much people doing stupid things ^^
I am so looking forward for that, in meantime I am exploring all possibilities.
Update : It freaking works now ( right after I hit this post button)
LOL it may just have been the SteemSQL database was overloaded as I suggested. Glad it is working. My new post will cover how to include specific tags from ALL post tags (and not just the category/1st tag). This is actually relatively tricky