Displaying 4 results from an estimated 4 matches for "data_precision".
2006 Jan 11
8
Oracle and Rails seems really slow.... In development
...reated_on", :datetime
t.column "email", :string
t.column "note", :text
end
And everything works fine, but in development, it has to run this query
for each view
select column_name, data_type, data_default, nullable,
decode(data_type, ''NUMBER'', data_precision,
''VARCHAR2'', data_length,
null) as length,
decode(data_type, ''NUMBER'', data_scale, null) as scale
from user_catalog cat, user_synonyms syn, all_tab_columns col
where cat.table_name = ''USERS''
and syn.synonym_name (+)= cat.table_name
and co...
2006 Feb 07
5
OCI adapter slowdown on dictionary access
Hi,
after some experience with Rails on MySQL databases I gave it a try on one
of our larger Oracle database.
I was facing a problem when Rails tried to detect the columns for a
model/table. The appropriate statement ran about 1 min which led to a
timeout.
Our Oracle guru told me to analyze the SYSTEM schema. After that hadn''t
helped, he said the only remaining chance is to use a
2006 Mar 23
11
ActiveRecord: Oracle metadata loading slow on large database
...ciency in
oci_adapter.rb. The problem seems to be the SQL being generated to
lazy-load the columns metadata. "def columns(table_name, name = nil)"
method generates the following SQL:
select column_name, data_type, data_default, nullable,
decode(data_type, ''NUMBER'', data_precision,
''VARCHAR2'', data_length,
null) as length,
decode(data_type, ''NUMBER'', data_scale, null) as scale
from user_catalog cat, user_synonyms syn, all_tab_columns col
where cat.table_name = ''#{NAME_OF_TABLE}''
and syn.synonym_name (+)= cat.table_n...
2006 Jan 04
3
Legacy Table works-except edit?
Greetings,
I''m trying to put a Rails face on a Legacy Oracle 10 table. I am
currently setting the table_name and primary_key, and I get the list
and show to work fine.
However, when I hit edit I just get the Editing <table name>, Edit
button, Show, and Back. None of the fields are rendered.
Why would I be able to show these fields in the show and list, but not
edit them in the