Well the facts are it was added without consultation, The result as we are also seeing on several other issues is that its might be supported but not for all databases and nobody knows its there. Infact we could say this about the whole Store system. Im sure there are several people who don't want to hear this but this is a result of adding or changing important parts without a good backing of the other committors. The whole database abstraction is now very unclear and seems to be based on 2 frameworks personally i have no clue how we got to this state but we do need to clear this up. Upto know it was _not_ normal for mmbase to add indexes because people told me it depends alot on the database used and is a db admins job, im not against adding it btw.
Daniel. -----Oorspronkelijk bericht----- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Namens [EMAIL PROTECTED] Verzonden: dinsdag 23 juli 2002 10:34 Aan: [EMAIL PROTECTED] Onderwerp: Re: mysql adding indexes > The RelationalDatabaseStorage, when properly configured, does add > primary and unique keys. > I checked a sample configuration in: 'relational.xml' in the database > config dir. Apparently, it's not clear at present whether indices should be created by MMBase, and what indices. Part of the problem is the fact that MMJdbc2NodeInterface is not documented, so its implementations may differ due to interpretational differences. If it should create indices as well, this ought to be documented somewhere. The issues brought up by Michiel are not specific to MySQL, or, if you want to put it that way: they should not be. Rob van Maris Developer
