On Mon, 2004-02-23 at 11:58, Michiel Meeuwissen wrote: > Joost Diepenmaat <[EMAIL PROTECTED]> wrote: > > I'm moving an mmbase application from a postgres database to mysql - > > which makes the whole application about 2.5 x faster - and I have a > > question about indexes / constraints on the tables mmbase creates. > > The would perhaps mean that your application is doing a lot of queries?
You could probably say that it's doing too many queries. Moving to mysql will give us some room to breath, while we fix the bigger issues. > I think we alway make unique key indices, and I think mmbase should > principally make them itself. Ok, so I'll run some more tests against it, but I'll probably leave it as it (with UNIQUE keys) > Are you using 1.7 with new storage layer? No, this is 1.6 (probably 1.6.0 - builddate.properties says 20021212) Joost.
