The issue wasn't that the Webassist PowerStore3 wasn't designed properly,,, The www.bluehost.com hosting company indicated that they didn't have a problem with their servers... and they were correct in saying that their server was working properly.. The problem was the simple thing and it caused problems everywhere in the software from items not showing up, slow population of photos to the screen when previewing data and screens just crapping out. If you look at the Control Panel for your phpMyAdmin, Server status, Slow_Queries and other server variables like "select_full_join" to determine the indexes that should be place on your table. I found that the following increased the speed of the entire system from the model T to the GT40....
I think it should be part of the db.sql when installing the powerstore 2 or 3
Create index options_index on ps3_options( OptionID asc, OptionGroupID)
Create index productcategories_index on ps3_productcategories( ProductID asc, ProductCategoryID asc)
Create index productoptions_index on ps3_productoptions( ProductID asc, OptionID asc, ProductCategoryID asc)
Create index products_index_pricing on ps3_products( ProductID asc, ProductPrice asc)
Create index products_index_photo on ps3_products( ProductID asc, ProductThumb asc)
Plus other indexs as needed....
Feels good to get past this issue:
Bob at www.busdevplanners.com