do u have any cache on the pipeline? can u run that part of code in some newer env, e.g. sa 0.4last / python2.5 and see how it works?
if u do clear_mappers() will it drop? On Wednesday 18 June 2008 16:59:20 Arun Kumar PG wrote: > hi all folks, > > i have a search form that allows user to search for records. i am > eager loading 4 attributes on the master object which results in 4 > left outer joins in the sa's sql query. the problem is that when i > look at the memory consumption using top command it looks crazy. > > the memory shoots up by 50-60 MB instantly (some times even 100+ > MB). i executed the query on db directly and the results are > returned in 3 secs (close to around 60,000 rows). sa is spending a > good amount of time processing the results and while it is doing > that i see abnormal memory growth. also the cpu is used almost 98% > during this time. > > the interesting thing is that after processing the request the > memory does not comes down. it stays there only. i dont know why > its not gc'ed. > > my environment: > - mysql 4.1 > - sa 3.9 > - python 2.4 > > is there any chance that memory is getting leaked as i don't see > memory come down even after some time. > > please give me some pointers as my app is totally based on sa. > memory and cpu consumption is too high. > > thanks. > > cheers, > > - a > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
