Dynamic row format in merge tables

[Erik Wetterberg]

Hi!
I have had some problems with a system using some merge tables. The underlying tables include a lot of empty fields so I tried to change row format to dynamic for all the underlying tables. But this gave me an error message saying that the underlying tables had different format..

I can't find anything in the documenation about dynamic row format in merge tables, is this an undocumented restriction ?

Is there any future in the merge storage engine? I tried replacing the merge table with a view (CREATE VIEW x AS SELECT * FROM a UNION ALL SELET * FROM b etc) and a quick test showed no difference in the queries we make. Since the VIEW approach means less limitations it seems better, since we make no inserts and updats in the merge table.And from the 5.1 version partitoning will be availabe, which will probably be better.

Erik Wetterberg


Gadgets for your Google homepage:
http://www.google.se/ig/authors?hl=en&author=[e-mail]



Edited 1 time(s). Last edit at 06/23/2007 08:08AM by Erik Wetterberg.