[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
"natalie chan" <natalie.channew@googlemail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: R: memory problem when using odbe to read in large dataset |

Date |
Sun, 13 Jul 2008 14:31:37 +0100 |

Dear Carlo, Thanks for your suggestion. I will try "compress" but do I need to increase the memory of the computer? for example, add a 1G memory stick. Many thanks. Natalie On Sun, Jul 13, 2008 at 2:19 PM, Carlo Lazzaro <carlo.lazzaro@tin.it> wrote: > > Dear Natalie, > I would suggest you to take a look at - help compress -. > > HTH and Kind Regards, > > Carlo > -----Messaggio originale----- > Da: owner-statalist@hsphsun2.harvard.edu > [mailto:owner-statalist@hsphsun2.harvard.edu] Per conto di natalie chan > Inviato: domenica 13 luglio 2008 14.27 > A: statalist@hsphsun2.harvard.edu > Oggetto: st: memory problem when using odbe to read in large dataset > > Dear Statalisters, > > I am trying to read in a dataset with more than 200 variables and 2 > million observations. the size of the dataset is 2.1G. I am using > Stata/MP 10 and Ram of the computer I am using is 1G > > I set the memory to 500m. the command I used was: > > odbc load, table ("firms") > > The stata produced the message "obs must be > between 62593 and 62593. As a possible solution, try increasing memory > using set memory ". > > I increased the memory to 700m, which is the maximum possible memeory > I can use, but still it did not work. > > Could anyone here give some advice? Thanks a lot. > * > * For searches and help try: > * http://www.stata.com/support/faqs/res/findit.html > * http://www.stata.com/support/statalist/faq > * http://www.ats.ucla.edu/stat/stata/ > > > * > * For searches and help try: > * http://www.stata.com/support/faqs/res/findit.html > * http://www.stata.com/support/statalist/faq > * http://www.ats.ucla.edu/stat/stata/ > * * For searches and help try: * http://www.stata.com/support/faqs/res/findit.html * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/

**Follow-Ups**:**Re: st: R: memory problem when using odbe to read in large dataset***From:*"natalie chan" <natalie.channew@googlemail.com>

**References**:**st: memory problem when using odbe to read in large dataset***From:*"natalie chan" <natalie.channew@googlemail.com>

**st: R: memory problem when using odbe to read in large dataset***From:*"Carlo Lazzaro" <carlo.lazzaro@tin.it>

- Prev by Date:
**st: R: memory problem when using odbe to read in large dataset** - Next by Date:
**Re: st: R: memory problem when using odbe to read in large dataset** - Previous by thread:
**st: R: memory problem when using odbe to read in large dataset** - Next by thread:
**Re: st: R: memory problem when using odbe to read in large dataset** - Index(es):

© Copyright 1996–2015 StataCorp LP | Terms of use | Privacy | Contact us | What's new | Site index |