It might make a difference on the DB you are using. Which are you using sqlite, postgresql, mysql?? What OS? As a side note if you are using windows, win32 only uses a little over 3gig as it uses the other for system use. But I'm not sure what the python limits are either.
On Wed, Feb 3, 2010 at 11:57 AM, Johann Spies <johann.sp...@gmail.com> wrote: > I am working with relatively large datasets (up to 450000 records) an > even when I try to minimize the memory usage by not doing a select on > all the fields I get this error on a 4G ram computer with a dataset of > about 150000 records): > > lys = db().select(db.wos_rou.id) > Exception in thread Thread-27: > Traceback (most recent call last): > File "/usr/lib/python2.5/threading.py", line 486, in __bootstrap_inner > self.run() > File "/home/js/web2py/gluon/contrib/cron.py", line 229, in run > shell=self.shell) > File "/usr/lib/python2.5/subprocess.py", line 594, in __init__ > errread, errwrite) > File "/usr/lib/python2.5/subprocess.py", line 1073, in _execute_child > self.pid = os.fork() > OSError: [Errno 12] Cannot allocate memory > > I cannot work like this. Is this a new bug? > > Regards > Johann > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.