Converting Buddypress xprofile_fields from vertical to horizontal database structure for more effici

Anyone have a solution to converting the vertical xprofile field database structure to a horizontal more efficient structure?

I have 10 million entries in my xprofile_data table and my site crashes everytime i try to filter anything with ajax... very frustrting.

i am going to extract the important xprofile fields and convert them to a horizontal database structure and point my search box to the new table.

anyone done this before?