Skip to content

Instantly share code, notes, and snippets.

@musoftware

musoftware/MySQL.md

Last active December 1, 2016 17:06
Show Gist options
  • Save musoftware/0b2ed03a5392cdb759660a23e7985a97 to your computer and use it in GitHub Desktop.
Save musoftware/0b2ed03a5392cdb759660a23e7985a97 to your computer and use it in GitHub Desktop.
Download ZIP
Fast Search In Database Mysql
Raw
MySQL.md

** MySQL

disadvantage

  • slow in FULL TEXT

to make it fast use ndb cluster as DB Engine and merge many servers

Raw
Sphinx.md

** Sphinx

advantage

  • very fast

disadvantage

  • need to create index from scratch to change data
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment