# Oracle multiple reload of model data using production web se

**URL:** <https://www.ruby-forum.com/t/oracle-multiple-reload-of-model-data-using-production-web-se/106434>\
**Category:** Rails\
**Created:** [June 10, 2007, 2:31pm UTC](https://www.ruby-forum.com/t/oracle-multiple-reload-of-model-data-using-production-web-se/106434 "2007-06-10T14:31:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dmcclean](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/91b2a8/32.png) [@dmcclean](https://www.ruby-forum.com/u/dmcclean)\
**Post date:** [June 10, 2007, 2:31pm UTC](https://www.ruby-forum.com/t/oracle-multiple-reload-of-model-data-using-production-web-se/106434/1 "2007-06-10T14:31:18Z")

</div>

When doing inserts into a HABTM model, I am seeing the meta data query  
being generated  
with every insert:

[4;36;1mitems\_releases Columns (0.020000) [0m [0;1m select  
column\_name as name, data\_type as sql\_type, data\_default, nullable,  
decode(data\_type, ‘NUMBER’, data\_precision,  
‘FLOAT’, data\_precision,  
‘VARCHAR2’, data\_length,  
null) as limit,  
decode(data\_type, ‘NUMBER’, data\_scale, null) as scale  
from all\_tab\_columns  
where owner = ‘CLIPS’  
and table\_name = ‘ITEMS\_RELEASES’  
order by column\_id  
[0m  
[4;35;1mSQL (0.010000) [0m [0mINSERT INTO items\_releases  
(item\_id, release\_id) VALUES (10783, 10796) [0m

If I do 20 inserts (all part of a save! operation by the parent of the  
HABTM), I get 20 queries for the model data.

This happens on a production web server. If I do the same operation  
using a MySQL db, I do not see  
the meta-data queries. Does anyone know why this would happed?

Thanks in advance,  
Don McClean