Hey all,

First, I'd like to mention that sqlobject is one of my all-time favorite python packages. Job well done!

However, for my latest project, I'm working on a worldwide monitoring system that tracks a large number of parameters. It takes in about 40,000 parameters / minute (thank god for huge RAID 5 arrays to write to). I initially implemented this all using SQLObject to interface to the DB backend for convenience. Once I started to ramp up the system, I noticed some bad memory usage.

After a couple hours of running, the python process takes up about 2 GB of RAM. I took SQLObject out and put direct calls to the DB in, and the memory usage is < 50 MB.

Any hints? I tried "del <object>" after I'm through with each of them. Is there some special connection handling I should do to get SQLObject to release the memory?

Thanks a bunch!

Brian

Attachment: smime.p7s
Description: S/MIME cryptographic signature

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to