select * incredibly slow response in CF 7?

[GaryG]

We upgraded to CF 7 over the weekend. Immediately users began reporting very
slow applications, but only in certain spots. After some time we realized that
only pages that issued "select *" type queries were being slow. We created
some test pages and found that, for instance, a select by fieldnames might take
5 seconds but the same query with a select * would take over a minute. The
same two queries at a regular SQL prompt comes back just as quick, regardless
of a * or not. We also have a copule of CF 5 machines still around and we
tested those and both queries return in 5 seconds.

Sure, we understand select * requires a bit more behind-the-scenes work, but
we are talking milliseconds. And this code has worked for year(s) in CF 6 and
probably even CF 5.

We're running Solaris 9 with Oracle 9. For CF 7 we took the included Oracle
driver but I just loaded the Oracle ojdbc14.jar driver and seem (at first
glance) to be getting the same result. In CF 6 we had some servers using the
included driver and others using Oracle's JDBC driver and never saw this
behaviour.

Has anyone experienced this? Although our developers are going back and
removing select *'s, I'm thinking the real solution is something either I'm
doing or have setup either in CF or Oracle. I haven't seen anyone talk about
this so I'm certainly guessing this is my problem and not a global CF / driver
/ Oracle issue as such.

Thanks in advance.

[jorgepino]

I would recomend not to use select * but to select the field you would be using with your (cfoutput>
Select field1,field2,fiield3 from ....
that shoudl increase somewhat the speed