mySQL/Buddypress expert needed to optimize database for search

mySQL/Buddypress expert needed to optimize database for search

Cancelled

Job Description

currently i use buddypress and xprofiles for user fields

the xprofile database is vertical, meaning instead of the columns being fields and rows being users, a new row is created everytime a user field is changed.

this makes my search extremely slow and inefficient.

looking for someone to create a new normalized database thats in correct format(horizontal) so that my search is optimized.

this new table must use triggers to be updated from the original xprofile fields database

please explain to me if you understand this problem. must be a mySQL expert

Other open jobs by this client