Slow due to usage of MySQLs LOWER() on string fields

[wulfsolter]

To re-open https://github.com/balderdashy/sails-mysql/issues/255

Workaround of "Workaround is to include the attribute wlNext: {caseSensitive: true} into sqlOptions in adapter.js." doesn't seem to be working anymore.

[sailsbot]

@wulfsolter Thanks for posting, we'll take a look as soon as possible. In the meantime, if you haven’t already, please carefully read the issue contribution guidelines and double-check for any missing information above. In particular, please ensure that this issue is about a stability or performance bug with a documented feature; and make sure you’ve included detailed instructions on how to reproduce the bug from a clean install. Finally, don’t forget to include the version of Node.js you tested with, as well as your version of Sails or Waterline, and of any relevant standalone adapters/generators/hooks.

Thank you!

[particlebanana]

@wulfsolter the wlNext option was never added to the my-sql adapter to my knowledge. I believe that currently only works in the postgresql and mongo adapters.

It would be a great addition to this adapter if anyone would like to take up the torch.

[wulfsolter]

Thanks @particlebanana , a bit of digging shows a quite promising fork done by @shamasis at postmanlabs/sails-mysql@d8bcd07 that I'll look into and come back with a PR shortly.

[sailsbot]

Thanks for posting, @wulfsolter. I'm a repo bot-- nice to meet you!

The issue queue in this repo is for verified bugs with documented features. Unfortunately, we can't leave some other types of issues marked as "open". This includes bug reports about undocumented features or unofficial plugins, as well as feature requests, questions, and commentary about the core framework. Please review our contribution guide for details.

If you're here looking for help and can't find it, visit StackOverflow, our Google Group or our chat room. But please do not let this disrupt future conversation in this issue! I am only marking it as "closed" to keep organized.

Thanks so much for your help!

If I am mistaken, and this issue is about a critical bug with a documented feature, please accept my sincerest apologies-- I am but a humble bot working to make GitHub a better place. If you open a new issue, a member of the core team will take a look ASAP.

[johnabrams7]

Referenced: balderdashy/sails-mysql#304