Closed Bug 559163 Opened 15 years ago Closed 15 years ago

Don't select from slow indexless views for just one item

Categories

(Firefox :: Sync, defect)

defect
Not set
normal

Tracking

()

RESOLVED FIXED

People

(Reporter: Mardak, Assigned: Mardak)

References

Details

Attachments

(1 file)

Should use .. UNION ALL .. LIMIT 1 instead
Does this improve the very slow history queries?
Target Milestone: --- → 1.3
Whiteboard: [b2]
Whiteboard: [b2]
Target Milestone: 1.3 → 1.3b3
Depends on: 560309
Attached patch v1 (deleted) — Splinter Review
Assignee: nobody → edilee
Status: NEW → ASSIGNED
Attachment #442516 - Flags: review?(mconnor)
Attachment #442516 - Flags: review?(mconnor) → review+
http://hg.mozilla.org/labs/weave/rev/662509211269 Just select from moz_places instead of _view where data might be slightly stale but good enough.
Blocks: 562378
Status: ASSIGNED → RESOLVED
Closed: 15 years ago
Resolution: --- → FIXED
No longer blocks: 562378
Blocks: 575423
Component: Firefox Sync: Backend → Sync
Product: Cloud Services → Firefox
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Creator:
Created:
Updated:
Size: