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

Lots of keys are being added to the postmeta table #4

Open
wjhdev opened this issue Dec 4, 2014 · 0 comments
Open

Lots of keys are being added to the postmeta table #4

wjhdev opened this issue Dec 4, 2014 · 0 comments
Labels
Milestone

Comments

@wjhdev
Copy link
Member

wjhdev commented Dec 4, 2014

Right now, there's a key/value for every hrld link in the format.

key: hrld-inline-$url
value: int (click count)

This is because there can be multiple inline links in any given post.

This is not ideal for sql, since there's an index on the key field. We should limit the number of keys being generated by making the key/value pair:

key: hrld-inline
value: array( "url1" => count1 , "url2" => count2 ... ) (serialized array)

Of course we'd have to write a script to alter the current database values.

@wjhdev wjhdev modified the milestone: v0.1 Dec 4, 2014
@wjhdev wjhdev added the bug label Dec 4, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant