subject:"\[sqlite\] R\: \[sqlite\] support for table partitioning\?"

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

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

2006-03-21 Thread Zibetti Paolo

> 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? > "Table partitioning" is a technique used to improve