Henrik,

About those 3K byte rows:

If you have one or more BLOB columns, or simply some very wide columns, and if the columns are rarely or never used in searches, I recommend that you consider removing them from the records in the primary table and store them in a secondary table designed to hold wide columns. When you need them, those wide columns can be accessed via a JOIN between the primary table and the secondary table.

This will do several things:

1. Significantly increase the "packing density" of the primary table.

2. Speed up searches involving primary table rows.

3. Isolate the inefficiencies of storing very wide data columns to the secondary table.

My suggestion involves just one scenario where this might make sense.

My suggestion has been implemented with good results.

Gail