▲ 3 ▼

How do I structure a Laravel feed query for 1M posts?

A Asha Sharma @asha_sharma · 1 week ago · 124 views ✓ Resolved

Im building a social feed and need pagination plus visibility gating. What indexes should I add?

#PHP #Laravel

16 Answers

▲ -2 ▼ ✓

S Super Admin @super_admin · 1 week ago ✓ Accepted

@asha_sharma okay

▲ 1 ▼

A Asha Sharma @asha_sharma1 · 1 week ago

Index (visibility, created_at DESC). Use keyset pagination for stable cursors. Consider Redis for hot-feed cache.

T Tanmay Ghosh @tanmay_ghosh · 1 week ago

test 1 gggggggggggggggg

▲ 0 ▼

T Tanmay Ghosh @tanmay_ghosh · 1 week ago

gfggggggggdf

▲ 1 ▼

T Tanmay Ghosh @tanmay_ghosh · 1 week ago

ghjjjjjjjjjjj

▲ 0 ▼

T Tanmay Ghosh @tanmay_ghosh · 1 week ago

okayyyyyyyyy

▲ 1 ▼

A Asha Sharma @asha_sharma · 1 week ago

2nd reply trying

▲ 1 ▼

T Tanmay Ghosh @tanmay_ghosh · 1 week ago

ghjjjjjjjj

▲ 1 ▼

S Super Admin @super_admin · 1 week ago

hidasf ggggggggggggggggg

▲ 0 ▼

S Super Admin @super_admin · 1 week ago

test 2 gggggggggggg

▲ 1 ▼

A Asha Sharma @asha_sharma · 1 week ago

hi test 2, how u r doing

▲ 1 ▼

A Asha Sharma @asha_sharma · 1 week ago

hi 287 kjhoujn euoquwejdqPI

▲ 0 ▼

T Tanmay Ghosh @tanmay_ghosh · 1 week ago

okkkkkkkkkkkkk

▲ 1 ▼

T Tanmay Ghosh @tanmay_ghosh · 1 week ago

y2k, brrrrr

▲ 1 ▼

T Tanmay Ghosh @tanmay_ghosh · 1 week ago

hgfhfghhfghfghfgh

▲ 0 ▼

I Ishita Bansal @ishita_bansal · 1 week ago

#php fghjkl ijhgffg #india