Here are some timings with different fetch sizes: ![]() What we gained is up to 96% performance improvement. By increasing fetch size, you increase the cache size in memory to fetch rows. OracleDataReader also has the FetchSize property. Notice the line with blue font, fetch size of command object increased by 8 times its default which is 128 KB at ODP.Net 11.2.0.3. OracleDataAdapter adap = new OracleDataAdapter(comm) OracleCommand comm = new OracleCommand() Ĭomm.CommandText = "select * from some_table" Using (OracleConnection conn = new OracleConnection()) If you can reduce the number of round trips, you can increase the fetch size so that in each turn command object will fetch more rows from database. The cause of the problem was the number of round trips client need to accomplish to get all the rows from database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |