SeoMaster Posted February 3, 2012 Share Posted February 3, 2012 Hey Alle, Fik denne mail fra Domaindirect i morges: du har et unødvendigt server-belastende SQL-kald der læser igennem ca. 3. mill. rækker. du skal ændre kaldet til noget fornuftigt og/eller rydde op i tabeller og/eller lave index, så SQL-kaldet ikke belaster servere unødvendigt. SELECT COUNT(DISTINCT cp.`id_connections`) FROM `ps1_connections_page` cp WHERE TIME_TO_SEC(TIMEDIFF(NOW(), cp.`time_start`)) < 900 LIMIT 1; Hvad er den bedste måde at løse problemet på? Link to comment Share on other sites More sharing options...
Guest Posted February 3, 2012 Share Posted February 3, 2012 Jeg ville rydde op i tabellen. Link to comment Share on other sites More sharing options...
presta-dyr Posted February 4, 2012 Share Posted February 4, 2012 Det sker typisk, når man går ind i back office. Lav et link til index.php?tab=AdminOrders, så går det hurtigere, og du belaster ikke serveren med det tunge request. /Kjeld Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now