Hello @alfanerd,
You are issuing queries like SELECT * FROM Comments WHERE ...
to build your stats, filtering on dates and posts.
Using the SELECT *
means you retrieve ALL columns from the table, including the body
column, which is absolutely useless for building your stats.
This kind of query, especially when targeting a full year, is a performance killer for SteemSQL infrastructure and negatively impacts responsiveness for other users.
I urge you to limit your SELECT clause to the required columns for your stats. Please update your queries or I will have to take steps to keep SteemSQL running smoothly!
Feel free to contact me on steemit.chat if you need any help.
Sorry my mistake. I will be more specific on my queries in the future.