Re: [R] creating a database

2007-12-19 Thread Moshe Olshansky
If all your entries are double precision then you are using 8 bytes per entry, so 20,000*n entries are just 160,000*n bytes, i.e. less than 160*n Kb. If your n is 100 you get 16 Mb which is not that much (especially if you pre-allocate it only once). So just use the matrix and don't worry! --- dxc

Re: [R] creating a database

2007-12-18 Thread elw
> Can a simple matrix be used for this or would it be better and more > efficient to create an external database to hold the data. If so, > should the database be created using C and how would I do this (seeing > as that I have never programmed in C)? You don't want to be down at the C level

Re: [R] creating a database

2007-12-17 Thread jim holtman
What are you intending to do with the data? How big is 'm'? How do you want to access the data? You can always put it in a SQL database that R can access and then pull out the rows that you are interested in. If 'm' is 100, then if you are just keeping numeric data, this will only require 16MB

[R] creating a database

2007-12-17 Thread dxc13
useR's, I am writing a program in which the input can be multidimensional. As of now, to hold the input, I have created an n by m matrix where n is the number of observations and m is the number of variables. The data that I could potentially use can contain well over 20,000 observations. Ca