Updates to Reviews beta site
I have updated the beta site with the new Left-hand only navigation frame. It's not perfect but it does give us a lot more real estate to work with.
I have also increased the font-size on review text and product text to 10pt. I could even increase it to 11 or 12 if people think its necessary, but it looks ok on my 1280x1024. Unfortunately I just can't really stop fixing the point sizes, otherwise all the menus and other navigational tools will get thrown out of whack. You can't design a good looking interface without fixing the point size.
Added to that is I'm not a web designer, I'm a software engineer, so its not really my specialty. If there is a web designer / HTML monkey who wants to help out, I'd be thrilled. I'm just trying to do the best I can.
As for data incrongruities, that should be cleaned up when we use a real data set. I had to experiment with the data during both development and the conversion process from MSAccess to MySQL, so some things may have gotten misdirected.
As for the performance improvement, it is not a result of using a smaller database. The database I'm using is just the site about a month ago, and it was slow as crap then too. I'm hoping that once this goes live the reviews section will be 10x more usable if only because it will be so much faster. Obviously, one of the big constraints is server CPU and memory utilization, which can't really be improved without upgrading. Also unfortunately we are running PHP for the boards and ASP for the rest of the site, which eats up extra resources. Especially since PHP installations on Windows 2000 boxes are rare and all the performance enhancing tools for PHP only work on Linux systems.
Ian