> >Now the problem is that depending on how big data is my query takes > >from a couple of Miliseconds up to 16 seconds to run. All results > >right up to about 1800 chars with in the data field take 10ms. Once I > >hit around 1800 it takes around 16 seconds to run. Then after about > >1850 it goes back down to 10ms. I can recreate the error again and > >again. However I cannot figure out what is going on.
So are you saying that any CLOB that has 1800 - 1850 characters takes 16 seconds to load, yet all other clobs load under 10ms? Its a bit perplexing if this is true. CLOB data, i belive under 4k is stored directly in the row, if the data is over this limit, a reference is stored instead. So you would see a bit of a speed difference between a 4k and a 5k blob, but not a 5k and 6k. (outside of the download speed.) Are you getting these tick counts from CF or from SQL*Plus/Toad? Be warned about updating drivers, you may fix one problem, but unleash all new ones. -Adam ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
