As mentioned earlier, I am trying to reduce the number of database queries. One of the biggest culprits here is the attribute and attribute price handling.

With the new database code I finally have all attribute data easily available and so it just needs some patience to follow the zen-cart code to find out what exactly has to happen and how to convert the code to use the already loaded data.

Right now I am using this product for comparison. With the current changes on trunk I have the number of $db queries down to around 590 337, compared to the whooping 1500 using 0.9.1. The best thing about it: I am not even finished