> "BD" == Berry, David writes:
BD> All variables are reals other than id which is varchar(10) and date
BD> which is a timestamp, approximately 1.5 million rows are returned by
BD> the query and it takes order 10 second to execute using psql (the
BD> command line client for Postgres) and a sim
On 12/02/2011 09:46 PM, Berry, David I. wrote:
> Thanks for the reply and suggestions. I've tried the RpgSQL drivers and
> the results are pretty similar in terms of performance.
>
> The ~1.5M records I'm trying to read into R are being extracted from a
> table with ~300M rows (and ~60 columns) th
On 01/12/2011 17:01, "Gabor Grothendieck" wrote:
>On Thu, Dec 1, 2011 at 10:02 AM, Berry, David I. wrote:
>> Hi List
>>
>> Apologies if this isn't the correct place for this query (I've tried a
>>search of the mail archives but not had much joy).
>>
>> I'm running R (2.14.0) on a Mac (OSX v 10.
On Thu, Dec 1, 2011 at 10:02 AM, Berry, David I. wrote:
> Hi List
>
> Apologies if this isn't the correct place for this query (I've tried a search
> of the mail archives but not had much joy).
>
> I'm running R (2.14.0) on a Mac (OSX v 10.5.8, 2.66GHz, 4GB memory) and am
> having a few perform
4 matches
Mail list logo
