Native Drivers.
Thanks,
-Doug
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Daryl Banttari
Sent: Saturday, March 30, 2002 10:29 AM
To: [EMAIL PROTECTED]
Subject: Re: [KCFusion] Query Problem
Misty,
Try using the Microsoft ODBC driver for Oracle (seriou
ve drivers, since Spectra uses CLOBs extensively.
HTH?
--Daryl
- Original Message -
From: "Misty Woodward" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 2002 11:38 PM
Subject: RE: [KCFusion] Query Problem
> Returns about 2k records. T
<[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: <[EMAIL PROTECTED]>
>Subject: [KCFusion] Query Problem
>Date: Wed, 27 Mar 2002 23:07:16 -0600
>
>I have been having a problem with huge differences in queries being run
>through a CF page and those run directly in a
the
first to see this happen, of course no one ever seems to get an answer on
the boards.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Ryan Hartwich
Sent: Wednesday, March 27, 2002 11:14 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Query Problem
If
If it's a big query and uses lots of ram, and your machine is out of ram
it would have to page the info to the hard drive. But if your run time
is consistent then that's not it.
Are you using the correct odbc drivers?
__
T
I have been having a problem with huge differences in queries being run
through a CF page and those run directly in an Oracle client. I understand
there might be some difference in time because of the overhead of CF but I
can't imagine why it would be so great. When I run this particular query
thr