codemonkeymike,
@codemonkeymike@fosstodon.org avatar

On a scale of 1 to Drupal, how janky is it to create a index on a text field like this?

Using a prefix index, as all I care about is the first 10 characters of the field for lookup purposes

vwbusguy,
@vwbusguy@mastodon.online avatar

@codemonkeymike Not a matter of jank, but if it's the right tool for the job. If that table has a lot of reads and less frequent writes, it makes sense to me.

  • All
  • Subscribed
  • Moderated
  • Favorites
  • random
  • tacticalgear
  • thenastyranch
  • ethstaker
  • everett
  • Durango
  • rosin
  • InstantRegret
  • DreamBathrooms
  • magazineikmin
  • Youngstown
  • mdbf
  • slotface
  • GTA5RPClips
  • kavyap
  • megavids
  • modclub
  • cisconetworking
  • cubers
  • ngwrru68w68
  • khanakhh
  • tester
  • anitta
  • normalnudes
  • Leos
  • osvaldo12
  • provamag3
  • JUstTest
  • lostlight
  • All magazines