Very Right, just wondering for few things so thought to post it to you guys
to know more stuffs.
regards,
Prashant
On Tue, Nov 25, 2008 at 9:53 AM, Marc Esher <[EMAIL PROTECTED]> wrote:
>
> My 2 cents: You'd be crazy to do it in straight java. If you do,
> you'll need to ensure you close your resultsets, statements and
> connections. And when you close your resultsets... you can't loop over
> them. In addition, the Flags you pass to your connection matter. If
> you want to scroll backwards and forwards (to get record count, for
> example), you need to pass the appropriate flags. And they will slow
> down your queries considerably. In addition, unless there's some magic
> with working with java ResultSet objects in CF, you'll still be stuck
> with:
>
> resultset.getString() and resultset.getInt() and that ugliness.
>
> There's a reason java developers use Hibernate instead of straight
> JDBC... it's that straight JDBC sucks to work with.
>
>
>
> On Tue, Nov 25, 2008 at 12:36 PM, [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> wrote:
> >
> > Hey CF Guys,
> >
> > I have executed a query with CFQuery Tag and then with CF Java
> > classes. Below is the matrix for performance.
> >
> > I have executed query for 14 times, Average time for query is as
> > below.
> > ---With CFQuery Tag = 748.714
> > --- With Java Classes = 769.14
> >
> > But the good thing about executing query with Java Objects, It tooks
> > more seconds for initial 4-5 times and after that it was taking less
> > time than CFQuery tag.
> >
> > I want to know your thoughts for this.
> >
> > -------------- Code ----
> > <cfset dsn=#application.dsn#>
> > <cfset value= 1326231>
> >
> >
> > <!--- executing query with <cfquery> Tag ---->
> > <cfset tickBegin = GetTickCount()>
> >
> > <cfquery name="q" datasource="#dsn#">
> > {CALL myStoredProc (
> > <cfqueryPARAM value = "#value#" CFSQLType =
> > "CF_SQL_INTEGER">
> > )
> > }
> > </cfquery>
> >
> > <cfset tickEnd = GetTickCount()>
> >
> > <cfset QueryTime = tickEnd - tickBegin>
> >
> > <cfoutput>
> > QueryTime : #QueryTime#
> > </cfoutput>
> >
> > <br />
> > ---------------------------------------------------------------- <br /
> >>
> > <!--- executing query with Java object ---->
> > <cfset sqlst="">
> > <cfset sqlst= sqlst & "exec Get_Patient_Header ">
> > <cfset sqlst= sqlst & "" & value & "">
> >
> > <cfset tickBegin = GetTickCount()>
> >
> > <cfscript>
> > objResults2 = CreateObject(
> > "java",
> > "coldfusion.sql.QueryTable"
> > ).Init(
> > CreateObject(
> > "java",
> > "coldfusion.server.ServiceFactory"
> > ).DataSourceService.GetDataSource(
> > "DSN_DEV"
> > ).GetConnection().PrepareStatement( sqlst).ExecuteQuery()
> > );
> > </cfscript>
> > <cfset tickEnd = GetTickCount()>
> >
> > <cfset QueryTime = tickEnd - tickBegin>
> >
> > <cfoutput>
> > QueryTime : #QueryTime#
> > </cfoutput>
> > >
> >
>
> >
>
--
- Prashant Roy
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CFCDev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfcdev?hl=en
-~----------~----~----~----~------~----~------~--~---
