Page MenuHomePhabricator

Wrong SQL : Data in the request !
Closed, ResolvedPublic

Description

Author: al2.baeckeroot

Description:
Many php functions are written using a temporary array which
has 3 nasty side effects:

  • its less understandable
  • it kills both sql server and php "server" by inducing huge IO
  • its damages mysql.log which are HUGE because we find the data

inside, introduce another slowdown, and prevent reading
mysql.log

USE SQL , dont subsitute php to myssql engine and it will be at
least 10 time faster !


Version: 1.3.x
Severity: critical

Details

Reference
bz1145

Event Timeline

bzimport raised the priority of this task from to Unbreak Now!.Nov 21 2014, 8:01 PM
bzimport set Reference to bz1145.
bzimport added a subscriber: Unknown Object (MLST).

bugzilla_wikipedia_org.to.jamesd wrote:

Please be more specific. With a generic comment it's not easy to work out
whether you're seeing a deliberate optimisation or a performance problem.

  • This bug has been marked as a duplicate of 1148 ***

aaron.schulz wrote:

content hidden as private in Bugzilla