Performance loss large Database

#2
[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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.