Displaying 4 results from an estimated 4 matches for "data_default".
Did you mean:
dao_default
2006 Jan 11
8
Oracle and Rails seems really slow.... In development
...do |t|
t.column "username", :string
t.column "created_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 = ...
2006 Feb 07
5
OCI adapter slowdown on dictionary access
.... If
anybody else has this problem or if anybody wants to include the change
into the next ActiveRecord version, here is what I''ve changed:
in activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb
at line 341 (in the #columns method):
- select column_name, data_type, data_default, nullable,
+ select /*+ RULE */ column_name, data_type, data_default, nullable,
Best regards and thanks for the great framework,
Andreas Gungl
2006 Mar 23
11
ActiveRecord: Oracle metadata loading slow on large database
...tabase, approx.
1700 tables and 4 million rows, I discovered an inefficiency 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 = ...
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