You are viewing a single comment's thread from:
RE: Blockchain Business Intelligence: Australia Tags Trend & Distribution
@steemitph, nice stats!
However, you should NOT use SELECT * in your queries because you will retrieve ALL columns from the table, including the body column, which is absolutely useless for building your stats.
This kind of query uses a lot of resources and bandwidth, and negatively impacts responsiveness for other users.
I urge you to limit your SELECT clause to the columns you need for your stats.
Feel free to contact me on steemit.chat if you need any help.
Hi @arcange, copy this. I will spend time this week to study the table structures and limit my queries to the columns I need. Thanks for your awesome work on the SQL Database.