Displaying 3 results from an estimated 3 matches for "table_cols".
2006 Jan 11
8
Oracle and Rails seems really slow.... In development
I''m just looking into how to connect to Oracle using Rails. I''ve got
everything connecting and working as it should.
I have a Users table in Oracle:
create_table "users", :force => true do |t|
t.column "username", :string
t.column "created_on", :datetime
t.column "email", :string
t.column "note", :text
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
...39;) ?
"''#{table_name.split(''.'').first}''" : "user"
table = "''#{table_name.split(''.'').last}''"
scope = (owner == "user" ? "user" : "all")
table_cols = %Q{
select column_name, data_type, data_default, nullable,
data_precision, data_length, data_scale
from #{scope}_catalog cat, #{scope}_synonyms syn,
all_tab_columns col
where cat.table_name = #{table}
and syn.synonym_name (...