▲ 1 ▼

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

A Asha Sharma @asha_sharma · 23 hours ago · 71 views ✓ Resolved

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

#PHP #Laravel

12 Answers

▲ -1 ▼ ✓

S Super Admin @super_admin · 7 hours ago ✓ Accepted

▲ 0 ▼

A Asha Sharma @asha_sharma1 · 23 hours ago

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

T Tanmay Ghosh @tanmay_ghosh · 5 hours ago

test 1 gggggggggggggggg

▲ 0 ▼

T Tanmay Ghosh @tanmay_ghosh · 5 hours ago

gfggggggggdf

▲ 0 ▼

T Tanmay Ghosh @tanmay_ghosh · 5 hours ago

ghjjjjjjjjjjj

▲ 0 ▼

A Asha Sharma @asha_sharma · 5 hours ago

2nd reply trying

▲ 1 ▼

T Tanmay Ghosh @tanmay_ghosh · 5 hours ago

ghjjjjjjjj

▲ 0 ▼

S Super Admin @super_admin · 5 hours ago

hidasf ggggggggggggggggg

▲ 0 ▼

S Super Admin @super_admin · 5 hours ago

test 2 gggggggggggg

▲ 0 ▼

A Asha Sharma @asha_sharma · 5 hours ago

hi test 2, how u r doing

▲ 0 ▼

A Asha Sharma @asha_sharma · 5 hours ago

hi 287 kjhoujn euoquwejdqPI

▲ 0 ▼

T Tanmay Ghosh @tanmay_ghosh · 5 hours ago

okkkkkkkkkkkkk

▲ 0 ▼