Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am fetching data from different tables residing in an Oracle Database and I am using the 11g ODBC driver, 64 bits. Two tables of approximately the same size in # of records (about 1 million) are read at completely different rates (records per second).
Same database, same connection string, similar query (Select * From Table). What can be causing such problem? Some extra configuration to be made?
I am experiencing the same behavior in 3 or 4 different tables, all other tables are read much faster, some even at rates of 10K records per second.
Any help is greatly appreciated.
Mike.
I made some tests, removing some fields to reduce the record size, but continued seeing the behavior. Then I went on to remove even more of the fields, and then add them gradually. I finally noticed that there was ONE specific field causing the bad performance: a BLOB field.
Regards,
Mike.
Mike
There are quite a few things that can affect the load rate. I am no expert on Oracle, but these are some of the things which generally affect relatove database table performance
There may be others, but these are the ones that come immediately to mind.
Jonathan
Thank you Jonathan, I will check into it.
Regards,
Mike.
I made some tests, removing some fields to reduce the record size, but continued seeing the behavior. Then I went on to remove even more of the fields, and then add them gradually. I finally noticed that there was ONE specific field causing the bad performance: a BLOB field.
Regards,
Mike.