Re: [sqlite] support for table partitioning?

2006-03-23 Thread John Stanton
Christian Smith wrote: On Tue, 21 Mar 2006, Miha Vrhovnik wrote: The database already knows exactly where to look for each table when all the tables are in the same file. All it has to do is "lseek()" to the appropriate spot. How does moving tables into separate files help this or make it an

Re: [sqlite] support for table partitioning?

2006-03-23 Thread Christian Smith
On Tue, 21 Mar 2006, Miha Vrhovnik wrote: >>The database already knows exactly where to look for each >>table when all the tables are in the same file. All it >>has to do is "lseek()" to the appropriate spot. How does >>moving tables into separate files help this or make it any >>faster? > >What

RE: [sqlite] R: [sqlite] support for table partitioning?

2006-03-22 Thread Thomas Briggs
om: Zibetti Paolo [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 21, 2006 9:22 AM > To: 'sqlite-users@sqlite.org' > Subject: [sqlite] R: [sqlite] support for table partitioning? > > > The database already knows exactly where to look for each > table when all > the

Re: [sqlite] support for table partitioning?

2006-03-21 Thread Miha Vrhovnik
>The database already knows exactly where to look for each >table when all the tables are in the same file. All it >has to do is "lseek()" to the appropriate spot. How does >moving tables into separate files help this or make it any >faster? What I had in my mind is this: CREATE TABLE measureme

Re: [sqlite] support for table partitioning?

2006-03-21 Thread drh
"Miha Vrhovnik" <[EMAIL PROTECTED]> wrote: > 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 const

Re: [sqlite] support for table partitioning?

2006-03-21 Thread drh
"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 fi

[sqlite] R: [sqlite] support for table partitioning?

2006-03-21 Thread Zibetti Paolo
to:[EMAIL PROTECTED] Inviato:martedì 21 marzo 2006 14.48 A: sqlite-users@sqlite.org Oggetto: Re: [sqlite] support for table partitioning? "Miha Vrhovnik" <[EMAIL PROTECTED]> wrote: > On 3/21/2006, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > &

[sqlite] support for table partitioning?

2006-03-21 Thread Miha Vrhovnik
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? Regards, Miha

Re: [sqlite] support for table partitioning?

2006-03-21 Thread Miha Vrhovnik
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 supo