c# - NHibernate Oracle CLOBs - very slow -


i have nhibernate mapping on tables in our oracle 11g database, 1 of tables contains clob column. when attempting query out ~10,000 rows of data, query takes forever. when querying subset of 200 rows, query ran 3 minutes. mathematically means it'll take 2.5 hours query 10,000 rows.

if remove clob column nhibernate mapping, same query takes ~3 seconds 200 rows, , ~2 minutes 10,000 rows.

is 1 of 'by design' issues, either oracle driver, or way nhibernate handles clobs?


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -