Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Slow persistence code checking #12

Closed
ahead4ltd opened this issue Jul 11, 2014 · 1 comment
Closed

Slow persistence code checking #12

ahead4ltd opened this issue Jul 11, 2014 · 1 comment

Comments

@ahead4ltd
Copy link

Currently persistence codes are stored in json format on the users table. When checking for a persistence code it has to perform (on average) a half table row scan just to determine the persistence code. As you can imagine, with a large users table this is a considerable performance hit. Ideally, the persistence codes should be split into a separate pivot table like so:

 user_id      persistant_code [indexed]
@ahead4ltd ahead4ltd changed the title Slow persistance code checking Slow persistence code checking Jul 11, 2014
@brunogaspar
Copy link
Member

This has changed, you can check the feature/updates branch if you want.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants