Also, the ReadFields query isn't impacted by how many records are in your tables. It just reads the metadata from the system tables about the tables themselves (column names, types, etc.).
On 5/14/07, Dan Wilson <[EMAIL PROTECTED]> wrote:
What about the number of rows of data in the table you are updating? If there were no indexes and the key you used to find the exact record to update required a full table scan, I can see a performance degradation. DW On 5/14/07, Bryan S <[EMAIL PROTECTED]> wrote: > Dan > > I'm guessing you'd consider this significant. I'm not sure if it would > account for the huge difference in speed though? > > > The tables that the MSSQL version queries followed by the number of rows in > the table: > INFORMATION_SCHEMA.COLUMNS - 63 > INFORMATION_SCHEMA.TABLE_CONSTRAINTS - 12 > INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE - 13 > > > The tables that the Oracle version queries followed by the number of rows in > the table: > all_tab_columns - 25616 > all_updatable_columns - 25616 > all_cons_columns - 11722 > all_constraints - 1498 > > > Bryan > > On 5/14/07, Dan Wilson <[EMAIL PROTECTED]> wrote: > > A question. Is there a significant variance in the number of rows in > > your MSSQL database and the Oracle database? > > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > Reactor for ColdFusion Mailing List > [EMAIL PROTECTED] > Archives at: > http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- "Come to the edge, he said. They said: We are afraid. Come to the edge, he said. They came. He pushed them and they flew." Guillaume Apollinaire quotes -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [EMAIL PROTECTED] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
