folllow up and more info
I removed all the advanced options I had installed. was only on 3-4 records as i a still testing. Is still running slow. I did notice something odd as well and not sure if it is a separte issue or part of the problem. when i added advanced options ( frame choice which changed the price and weight) it wants me to manage inventory, which i initially ( and it still shows) do not need to keep track of inventory.. I have another category with no options being used and there is no manage inventory.