On 3/21/2006, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
>"Miha Vrhovnik" <[EMAIL PROTECTED]> wrote: >> Hi drh and others, >> >> Regarding the issues they appear on ML with very large tables and knowing >> that sqlite now enforces constraint checks on tables, is there any >> chances of suporting table partitoning? >> > >Put each table in a separate database file then ATTACH >the databases. >-- >D. Richard Hipp <[EMAIL PROTECTED]> > That's not the same. You still need to rewrite queries, where in real table partitioning you don't need to do that. The select's and inserts are faster because db knows where to put/search for them. Regards, Miha