-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Simon Gray wrote: | Paul J Stevens wrote: |> Since the Query_time is 0 seconds, what is the problem? I'm not saying |> the |> situation can't be improved, but I seriously doubt splitting the query |> will do |> the job. | Agreed, it isn't a problem at the moment, but we're adding more and more | imap users each with many gb mailboxes - Its just that I can see this | becoming an issue in the future. | | Simon Simon
I doubt that splitting the queries will change whether an index is used. The potential index on mailbox_idnr is not a good one when there are many rows corresponding to mailbox_idnr. Did you try to explain the separated queries? The behaviour should be the same as in the combined select. John -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFIGAvRd4I3jTtt9EIRAgrmAJ9RWxOkuc3pCZN1qmzlQxc41jeqZQCgmqlL QdsaWIqhtFTzVtPao4CQAks= =bH5c -----END PGP SIGNATURE----- _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
