# How to reduce number of queries

**URL:** <https://www.ruby-forum.com/t/how-to-reduce-number-of-queries/193539>\
**Category:** Rails\
**Created:** [August 19, 2010, 12:31pm UTC](https://www.ruby-forum.com/t/how-to-reduce-number-of-queries/193539 "2010-08-19T12:31:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![the-lar](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/ad7895/32.png) [@the-lar](https://www.ruby-forum.com/u/the-lar)\
**Post date:** [August 19, 2010, 12:31pm UTC](https://www.ruby-forum.com/t/how-to-reduce-number-of-queries/193539/1 "2010-08-19T12:31:17Z")

</div>

Hi ,  
presently i have one problem,  
Ex:  
i have 6 services  
SERVICES = {  
:project\_title =\> ‘Tilte’,  
:project\_description =\> ‘Description’,  
:created\_at =\> ‘Created At’,  
}  
In these way i have 8 services  
For each service i would like to give 4 permissions  
1)create 2)read 3)write 4) update  
all services are having same permissions  
But know when i am writing the code

Site::SERVICES.keys.each do |service\_key|

@site= User.new(:service\_name =\>  
Userr::SERVICES[service\_key.to\_sym],:user\_id =\> partner\_id, :user\_type  
=\> “Partner”)

```
          @site.read_access = true
          @site.create_access = true
          @site.update_access = true

```

end

It is raising 8 Queiries for 8 Services and if services number increases  
then Number of queries are also increases  
So It is not good  
I want to find the solution with a single Query !!!  
Is it Possible??