DK <[EMAIL PROTECTED]> wrote: > On 6/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > DK <[EMAIL PROTECTED]> wrote: > > > There is data like email aliases which need to be accessed by the MTA. > > > It wouldn't be a good idea to open each users db to check the aliases > > > for each email that arrives. So what we would need is a common db > > > which mirrors one table from all the user databases. > > > > Have one database containing email aliases and/or other shared > > information and then one email per user. Then use the ATTACH > > command to join them together at runtime. See > > > > http://www.sqlite.org/lang_attach.html > > > > -- > > D. Richard Hipp <[EMAIL PROTECTED]> > > > > Thanks Richard, > But it says: "There is a compile-time limit of 10 attached database > files" If this means max db 10 then this is no good we will have more > then 10 users. >
You are probably not serving all your users all at once. Just ATTACH and DETACH user databases on an as-needed basis. -- D. Richard Hipp <[EMAIL PROTECTED]>
