mySQL/Buddypress expert needed to optimize database for search
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