Make WordPress Core

Opened 17 years ago

Closed 16 years ago

#2043 closed defect (bug) (fixed)

Dirty cache queries

Reported by: matt's profile 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)

#1 @ryan
17 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.

#2 @matt
17 years ago

  • Milestone changed from 2.0 to 2.1

#3 @markjaquith
17 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.

#4 @matt
17 years ago

  • Milestone changed from 2.1 to 2.2

#5 @foolswisdom
16 years ago

  • Milestone changed from 2.2 to 2.3

#6 @ryan
16 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.