Needs Updating

Running a JOIN on two columns of different types may force a sequential scan.

Example:

If foo.a and bar.b are not of same type, the query planner will need to cast the data of each foo.a and bar.b entry. This happens using any database, incuding MySQL and PostgreSQL.

Even if the cast happens on memory only, it will consume CPU time, at least one cycle per row and hence will be very slow. On very large tables, this should be avoided.

More examples soon.

These handbook pages are a companion to UPGRADE.txt. You are encouraged to read all the handbook pages describing the upgrade process as UPGRADE.txt only covers the steps taken after you have prepared your current Drupal site for upgrade.

To get a copy of UPGRADE.txt, download the latest version of Drupal 7 from http://drupal.org/project/drupal. Extract the archive with a program like tar, 7zip or a similar utility that comes with your operating system.

In the root folder of the downloaded Drupal package you will find the UPGRADE.txt file. This file contains a list of actions you will need to perform to upgrade a Drupal site. It is important to read and understand the contents of this file as you will refer to it regularly during the upgrade process.

Please add your website if you are using node gallery, and say a few words about your setup and your website.

Questions from the Issue que

Will there be a Boost version for D7?

Boost will be ported to D7, it's on the Todo list. (active)

What effect does Boost have on SEO? (search engine optimization)

Because of faster page loading there is a slight improvement for SEO. There has been multiple reports of more page hits after installing Boost, and improved ranking on Google. In terms of improving SEO even more, assuming fast page loads = better SEO, enabling "Expire content in DB, do not flush file" would help. Just make sure cron runs consistently if doing this; or use the rules cron run trick.

Can cache be saved into sub folders to limit the files in a single folder within the node folder?

This is difficult as it can't be generalized. If anyone posts a patch that is generalized and a good idea, it will be added to Boost. (postponed)

I have polls on my website, an anonymous visitor after voting doesn't see the results in the poll block.

An AJAX block module is whats needed. (active)

Boost handles the dynamic expatriation of comments, nodes, taxonomy, views and user pages. What about panels?

We are almost there, panels is next on the Todo list. (active)

A note from the developers:
The 6.x-2.x-alpha11 release is working well in it's current form. 6.x-2.x is a complete re-write and has been in development since 2009-06-01. Many issues that are present now are being worked on as we prepare a beta release. Additional features and fixes are found in 6.x-2.x-dev as they are finalized and made ready.
Development requires time and testing. We are making very good progress towards providing a gallery solution for Drupal.

Your Drupal Status report page returns the following error

GD Image Rotation Low Quality / Poor Performance
The installed version of PHP GD does not support ...

Here is the steps for Ubuntu Server 8.04.x LTS, PHP5, Drupal 5.x or 6.x. It has also been found to work with Ubuntu Server 9.04. It will install a GD pre-compiled fully working version. It is a complete bundled (forked) GD libraries.