So, I've created a hello world pylons app as a little test case
because I'm running into some memory issues with another pylons app.
(hello world app details below)
When I first launch the app (on my dev box), the memory profile looks
like this:
VIRT=138m
RES=20m
When I do a select * from a table with 90845 rows [Session.query
(PreLog).all()], the memory goes to the following and then holds
_forever_.
VIRT=348m
RES=182m
I had suspected that eventually garbage collection would kick in and
release the SQL result set (or whatever SQL metadata it's holding on
to), but that doesn't seem to be the case.
Any ideas? Surely, I'm missing some config option or something. The
code that deviates from the default (paster create & paster
controller) is as follows.
Thanks for your time,
--diana
I basically:
$ paster create -t pylons logs
$ paster controller pre_logs
And then modified:
---- MySQL ----
CREATE TABLE `pre_log` (
`modified` timestamp NOT NULL default CURRENT_TIMESTAMP,
`id` int(11) NOT NULL auto_increment,
`batch_id` int(11) NOT NULL,
`action` varchar(100) default NULL,
`profile_id` varchar(25) default NULL,
`start_datetime` datetime default NULL,
`end_datetime` datetime default NULL,
`status` varchar(25) default NULL,
`message` varchar(1000) default NULL,
PRIMARY KEY (`id`),
KEY `batch_id` (`batch_id`)
) ENGINE=MyISAM AUTO_INCREMENT=351808 DEFAULT CHARSET=utf8
---- routing.py ----
# CUSTOM ROUTES HERE
map.connect('pre_logs', '/pre_logs', controller='pre_logs',
action='index')
---- model/__init__.py ----
def init_model(engine):
global reflected_table
reflected_table = sa.Table("pre_log", meta.metadata, autoload=True,
autoload_with=engine)
orm.mapper(PreLog, reflected_table)
meta.Session.configure(bind=engine)
meta.engine = engine
class PreLog(object):
pass
---- meta.py ----
__all__ = ['Session', 'engine', 'metadata']
engine = None
Session = scoped_session(sessionmaker())
metadata = MetaData()
---- controllers/pre_logs.py ----
class PreLogsController(BaseController):
def index(self):
pre_log_query = Session.query(PreLog)
result = pre_log_query.all()
count = len(result)
return 'Hello World %s' % (count)
---- ini ----
[DEFAULT]
debug = false
[app:main]
sqlalchemy.url = mysql://foo:b...@localhost:3306/logs_db?charset=utf8
set debug = false
---- OUTPUT ----
Hello World 90845
--
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/pylons-discuss?hl=en.
