I'm redoing my website and i'm in the finetuning phase...

But there is one wall i seem to run in over and over

all products lod just fine.. only the "dream"-product is terribly slow. It has to do with the amount of options and the speed of how fast these options are "pulled" from the database and put into the display. any suggestions?

Zencart: 1.3.7.1
PHP Version: 4.4.7 (Zend: 1.3.0)
Database: MySQL 4.1.22-standard

i'd also like suggestions if you find more flaws...