# Disabling 'show status' in activerecord because of overhead of spawning process

**URL:** <https://www.ruby-forum.com/t/disabling-show-status-in-activerecord-because-of-overhead-of-spawning-process/190747>\
**Category:** Rails\
**Created:** [June 26, 2010, 3:24pm UTC](https://www.ruby-forum.com/t/disabling-show-status-in-activerecord-because-of-overhead-of-spawning-process/190747 "2010-06-26T15:24:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![luckydeepak](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/958977/32.png) [@luckydeepak](https://www.ruby-forum.com/u/luckydeepak)\
**Post date:** [June 26, 2010, 3:24pm UTC](https://www.ruby-forum.com/t/disabling-show-status-in-activerecord-because-of-overhead-of-spawning-process/190747/1 "2010-06-26T15:24:07Z")

</div>

hi,  
i have a app which has a spiky activity, there a large period of  
inactivity between request. With phusion-passenger after a period of  
inactivity the process is killed, and when the app is respawned the  
‘show status’ queries take more time than the actual sql themself.

I know that ActiveRecord makes the ‘show status’ query once on  
spawning the server, but is there some way of disabling ‘show status’  
in activerecord, because of overhead of spawning process.

Alternatively, can i cache only the ‘show status’ queries in memcache/  
redis

thanks,  
deepak

---

<div class="post-metadata">

**Author:** ![luckydeepak](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/958977/32.png) [@luckydeepak](https://www.ruby-forum.com/u/luckydeepak)\
**Post date:** [July 12, 2010, 11:37am UTC](https://www.ruby-forum.com/t/disabling-show-status-in-activerecord-because-of-overhead-of-spawning-process/190747/2 "2010-07-12T11:37:15Z")

</div>

hi,  
any suggestions, the show status queries are very redundant and makes  
the startup slow.

Can i memonize it?

cheers,  
deepak