Thank you for your quick response.
Yes, we do know about views, but have not yet created them in IQ...
although we have created extensive indexes and
and yes, it is newer and different from SQL Advantage in a number of
annoying ways. We are using IQ for our datawarehouse needs.
Hopefully when we get it all working it will be as speedy as we
know it has to be.
Thanks again.
Carol
Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335
[EMAIL PROTECTED]
____________________Reply Separator____________________
Subject: Re: Performance question - CFINCLUDE versus writing a cus
Author: [EMAIL PROTECTED]
Date: 1/31/01 12:09 PM
Stored Procedures are a database function. I suggest looking in your
database docs. I've done some work with
Sybase SQL Anywhere a few years back. If memory serves me, they had something
called views, which were akin to
stored procedures. Don't hold me to that though.
I'm not sure what you mean when you say Sybase IQ. New product? Same
Product? I haven't kept up on the Sybase
product line.
Once you have the stored procedure created, you can reference it through SQL
or using the CFSTOREDPROC tag.
Carol Bluestein wrote:
> We are managing huge SYBASE IQ databases and looking for ways to increase
> performance. Your comment on stored procedures (5x quicker) really caught my
> attention since our queries are also huge. I check allaire's knowledge base
and
> my current CF books (incl.Forta's Advanced Cold Fusion 4.0) and can find
> nothing extensive. Is this all there is or are there other sources of
> information
> re: STORED PROCEDURES. Any help with information or pointing me towards
> information would be very helpful.
>
> Thanks,
> Carol
>
> Carol L. Bluestein
> Senior Programmer
> NYS Office of Real Property
> 518-486-6335
> [EMAIL PROTECTED]
>
> ____________________Reply Separator____________________
> Subject: Re: Performance question - CFINCLUDE versus writing a custom
> Author: [EMAIL PROTECTED]
> Date: 1/30/01 5:24 PM
>
> Converting intensive queries to stored procedures is the single most
> performance tweak you can do for a CF site. I've seen SP's perform up to 5
> times as fast as a regular <cfquery>
>
> jon
> ----- Original Message -----
> From: "Kevin Gilchrist" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, January 30, 2001 4:00 PM
> Subject: Re: Performance question - CFINCLUDE versus writing a custom CF
>
> > Unfortunately stored procedures aren't an option.
> > What would that gain me anyway? Is it just more efficient for the queries
> > to be executed by the DB (Oracle in this case)?
> >
> > Going by Philip's answer, I guess doing CFINCLUDE'a are the way to go.
> >
> > "Steve Bernard" <[EMAIL PROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > Are stored procedures not an option?
> > >
> > > Steve
> > >
> > > -----Original Message-----
> > > From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, January 30, 2001 12:07 PM
> > > To: CF-Talk
> > > Subject: Performance question - CFINCLUDE versus writing a custom CF
> > >
> > >
> > > Hi all,
> > >
> > > I'm writing a web app that acts as a dashboard for an MSP, i.e. a GUI
> that
> > > shows the status of all sorts of applications, network and host
> devices.
> > I
> > > need to write quite a few select queries for each device/host/app type,
> so
> > > will end up with ~150 different queries.
> > >
> > > What I'm wondering about is if anyone has any thoughts on whether it's
> > > better to access these queries from the GUI templates using
> > >
> > > - a series of conditional CFINCLUDE's that would include a smallish
> query
> > > template.
> > >
> > > - or write a custom CF tag with all the queries inside and pass three
> > > parameters that would give me a unique query name. A three deep CFWITCH
> > > statement could home in on the relevant query.
> > >
> > > Is it correct to assume that it's a bigger hit on CF to call on a
> > relatively
> > > large templates even though it's doesn't have to process much of it (cf_
> > > tag), as opposed to including whole but small templates?
> > > I guess it may be better organizationally to implement the queries as a
> > > bunch of small files to include?
> > >
> > > It seems like a case of six in one, half a dozen in the other but I'll
> > never
> > > know if I don't ask...
> > >
> > > Thanks,
> > > Kevin
> > >
> > > P.S. I intend to convert it all to fusebox for version 2.
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
