Ticket #5699 (closed enhancement: fixed)

Opened 9 months ago

Last modified 9 months ago

get_col() instead of get_results() for increased performance

Reported by: fitztrev Assigned to: anonymous
Priority: low Milestone: 2.5
Component: General Version:
Severity: minor Keywords:
Cc:

Description

Using get_results() is overkill for what's being selected in this query.

get_col() should have faster parsing times.

Attachments

get_col.diff (0.6 kB) - added by fitztrev on 01/21/08 08:05:00.
get_col2.diff (0.7 kB) - added by fitztrev on 01/21/08 22:44:25.

Change History

01/21/08 08:05:00 changed by fitztrev

  • attachment get_col.diff added.

01/21/08 08:15:47 changed by ryan

I think do_trackbacks($trackback->ID) would need to become do_trackbacks($trackback).

01/21/08 22:44:25 changed by fitztrev

  • attachment get_col2.diff added.

01/21/08 22:45:38 changed by fitztrev

That's absolutely correct. Here is the updated patch. Tested, this time.

01/22/08 05:50:22 changed by ryan

  • status changed from new to closed.
  • resolution set to fixed.

(In [6640]) get_col() instead of get_results(). Props fitzrev. fixes #5699