Re: [Rd] RSQLite indexing

2007-10-22 Thread Seth Falcon
Jeffrey Horner <[EMAIL PROTECTED]> writes: > Thomas Lumley wrote on 10/22/2007 04:54 PM: >> I am trying to use RSQLite for storing data and I need to create indexes on >> two variables in the table. It appears from searching the web that the >> CREATE >> INDEX operation in SQLite is relatively

Re: [Rd] RSQLite indexing

2007-10-22 Thread Kasper Daniel Hansen
On Oct 22, 2007, at 2:54 PM, Thomas Lumley wrote: > > I am trying to use RSQLite for storing data and I need to create > indexes on > two variables in the table. It appears from searching the web that > the CREATE > INDEX operation in SQLite is relatively slow for large files, and > this ha

Re: [Rd] RSQLite indexing

2007-10-22 Thread Marcus G. Daniels
Thomas Lumley wrote: >> How big is your dataset? SQLite can be slow, but I didn't think it >> was that slow. >> > > 35x100 entries on 12 variables > I had a similar problem a while back and took the opportunity to test various RDBMS. I found that a product called TimesTen from Oracl

Re: [Rd] RSQLite indexing

2007-10-22 Thread Jeffrey Horner
Thomas Lumley wrote on 10/22/2007 04:54 PM: > I am trying to use RSQLite for storing data and I need to create indexes on > two variables in the table. It appears from searching the web that the CREATE > INDEX operation in SQLite is relatively slow for large files, and this has > been > my exp

Re: [Rd] RSQLite indexing

2007-10-22 Thread Thomas Lumley
On Mon, 22 Oct 2007, hadley wickham wrote: > On 10/22/07, Thomas Lumley <[EMAIL PROTECTED]> wrote: >> >> I am trying to use RSQLite for storing data and I need to create indexes on >> two variables in the table. It appears from searching the web that the CREATE >> INDEX operation in SQLite is rel

Re: [Rd] RSQLite indexing

2007-10-22 Thread hadley wickham
On 10/22/07, Thomas Lumley <[EMAIL PROTECTED]> wrote: > > I am trying to use RSQLite for storing data and I need to create indexes on > two variables in the table. It appears from searching the web that the CREATE > INDEX operation in SQLite is relatively slow for large files, and this has > been

[Rd] RSQLite indexing

2007-10-22 Thread Thomas Lumley
I am trying to use RSQLite for storing data and I need to create indexes on two variables in the table. It appears from searching the web that the CREATE INDEX operation in SQLite is relatively slow for large files, and this has been my experience as well. The two index variables are crossed.

Re: [Rd] install.packages() and configure.args

2007-10-22 Thread Robert Gentleman
since, in Herve's example only one package was named, it would be nice to either, make sure configure args are associated with it, or to force only named configure.args parameters, and possibly check the names? Duncan Temple Lang wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi

[Rd] predict.gnls seems to break when 'newdata' specified (PR#10364)

2007-10-22 Thread jenny
Full_Name: Jennifer Bryan Version: 2.5.1 OS: Mac OS 10.4.10 Submission from: (NULL) (142.103.104.81) The predict method for gnls seems to break when I provide 'newdata'. It seems to be the code that checks that the factors in newdata have the same contrasts as the data provided for the original

[Rd] bug in detection of zero state for Mersenne Twister (PR#10362)

2007-10-22 Thread savicky
Full_Name: Petr Savicky Version: all versions starting from 1.7.0 OS: observed on Linux, but is platform independent Submission from: (NULL) (62.24.91.47) The function runif(n) contains a protection against the zero state of Mersenne Twister stored in .Random.seed. If the state is zero, it is reg