Boldozar

Experience

100

0 Best Reply Awards

  • Member Since 4 Weeks Ago
  • 0 Lessons Completed
  • 0 Favorites

17th September, 2018

Boldozar left a reply on Dealing With Huge Tables • 4 weeks ago

@Cronix @Snapey Thanks for help

Boldozar left a reply on Dealing With Huge Tables • 4 weeks ago

@Cronix @Snapey im trying to get all polls and count options and answers for each one

Boldozar left a reply on Dealing With Huge Tables • 4 weeks ago

@Cronix yes all foriegn keys are indexed here is a link for the schema https://www.insystems-eg.com/pics/Capture.PNG

Boldozar left a reply on Dealing With Huge Tables • 4 weeks ago

@Snapey im trying to get all polls with all it's options and answers using eager loading,, here is the using Poll::with('options','answers')->get()

Boldozar left a reply on Dealing With Huge Tables • 4 weeks ago

@Snapey it was huge for me :D what more details i can share?

Boldozar started a new conversation Dealing With Huge Tables • 4 weeks ago

im working on polls script i have 3 tables which are polls , options , answers i have 942 poll ,, 10 options for each poll ,, and around 5000 answer for each option in the problem comes with calling data using eager loading the request takes too long ,, any ideas for optimizing the script?

Edit Your Profile
Update

Want to change your profile photo? We pull from gravatar.com.