Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Archived Discussions Archived General Discussion Performance loss large Database
Performance loss large Database
  • El Forum
    Guest
  •  
#2
10-19-2014, 11:25 AM

[eluser]jonez[/eluser]
Instead of doing one query to pull the ID's then 300 subqueries for tour details do it all as a single query join and delegate the array. It should not take 6s to compile a view from data, can you post some code on how you're building the view?


Messages In This Thread
Performance loss large Database - by El Forum - 10-19-2014, 08:23 AM
Performance loss large Database - by El Forum - 10-19-2014, 11:25 AM
Performance loss large Database - by El Forum - 10-19-2014, 11:26 AM
Performance loss large Database - by El Forum - 10-19-2014, 02:52 PM
Performance loss large Database - by El Forum - 10-19-2014, 05:00 PM
Performance loss large Database - by El Forum - 10-20-2014, 12:55 AM
Performance loss large Database - by El Forum - 10-20-2014, 05:16 AM



Theme © iAndrew 2016 - Forum software by © MyBB