You are viewing a single comment's thread from:

RE: Turkish Community's Statistics on Steemit | January

in #utopian-io7 years ago

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.

Sort:  

Sorry my mistake. I will be more specific on my queries in the future.