Forem: Vikas Rai

Discussion: How to find top n users with five recent posts

Vikas Rai — Thu, 28 May 2020 14:14:33 +0000

Hello all,

I hope all are fine in this lockdown and learning new things in this period. I want to discuss something with you guys.

THE OPTIMAL WAY OF FINDING RECORDS FROM THE DATABASE.

Let us say, the users who have multiple comments on different posts and they are stored in users, comments and posts tables respectively. On a dashboard page we want to list top n users with the most five recent comments on different posts. HOW would you achieve this through the query? If possible, write your query also and the reason that your query is the most optimal one.

Rendering a table with dynamic rows and dynamic header in Vue.js

Vikas Rai — Tue, 12 May 2020 17:05:57 +0000

Hello all,

This is my post and I wrote this to seek some help or advice from you. I am rendering a table in which the header and rows are dynamic. Each cell is a different Vue component. The cell is a select drop-down and the options can contain 10k items. I have started testing this table with larger dataset say 100 thead and 50 rows. Each cell has about 5k options. The page becomes simply unresponsive. How would I tackle this situation? Should I load dataset in the cell only when focused? Moreover, when I click on the drop-down, it takes time to expand and retract.