WordPress.org

Make WordPress Core

Opened 9 years ago

Closed 7 years ago

#2043 closed defect (bug) (fixed)

Dirty cache queries

Reported by: matt Owned by:
Milestone: 2.3 Priority: normal
Severity: normal Version: 2.0
Component: Administration Keywords:
Focuses: Cc:

Description

When the cache is dirty or something and file-based caching is being used, a query is done for every unique option call, so a page that without caching would do 20 queries can do 40+.

Expected result: The in-memory grab all options thingy would keep options queries at 1.

Change History (6)

comment:1 @ryan9 years ago

Works for me. The only option queries I see in either mode are the initial query to test the DB and queries for non-existent options.

comment:2 @matt9 years ago

  • Milestone changed from 2.0 to 2.1

comment:3 @markjaquith9 years ago

I've seen this happen. We need some sort of counter for options queries so that once 2 or 3 have gone by manually it goes "wait a second, these should be cached" and then grabs all the autoload options in one query.

comment:4 @matt8 years ago

  • Milestone changed from 2.1 to 2.2

comment:5 @foolswisdom8 years ago

  • Milestone changed from 2.2 to 2.3

comment:6 @ryan7 years ago

  • Resolution set to fixed
  • Status changed from new to closed

I think the alloptions cache takes care of this now.

Note: See TracTickets for help on using tickets.