Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

Task #10885 (new)

Opened 7 years ago

Last modified 4 years ago

UTF-8 text columns require extra index

Reported by: jamoore Owned by:
Priority: critical Milestone: Unscheduled
Component: ORM Version: n.a.
Keywords: n.a. Cc: mtbcarroll, bpindelski, jburel, cxallan, cneves, wmoore, aknab
Resources: n.a. Referenced By: n.a.
References: n.a. Remaining Time: n.a.
Sprint: n.a.

Description

For UTF-8 databases (which we suggest), the default "create index..." command is not sufficient for like queries. A second index with varchar_pattern_opts is needed. It's unclear which of our queries may profit from this.

See: https://code.djangoproject.com/ticket/12234

Change History (1)

comment:1 Changed 4 years ago by jamoore

  • Cc changed from mtbcarroll,bpindelski, jburel, cxallan, cneves, wmoore, aknab to mtbcarroll, bpindelski, jburel, cxallan, cneves, wmoore, aknab
  • Milestone changed from 5.x to Unscheduled
Note: See TracTickets for help on using tickets. You may also have a look at Agilo extensions to the ticket.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.73594 sec.)

We're Hiring!