You must have a really good reason granted that direct database would be the faster,
and more flexible alternative here. I guess you can try something that would build a
.csv file in a trigger.
Remember that a database is essentially a file in itself, and no matter what you are
doing you are still accessing a file, no matter where it is. Either way has a
performance overhead. Might as well use SQL, unless there is something else I'm not
aware of.
Gregory Harris
Los Angeles Information Technology Agency (ITA)
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 08/16 10:42 AM >>>
I want to keep calls to the database to a minimum.
Michael Slatoff
www.slatoff.com
-----Original Message-----
From: "Gregory Harris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Date: Wed, 16 Aug 2000 10:23:51 -0700
Subject: Re: SQL Trigger vs. Stored Procdure
> You could do that I suppose, but why not just store your navigation
> table information, HTML and all INSIDE the database rather than as a
> separate file under the guise of SQL....makes more sense to me....you
> can bring up the HTML up through a SQL Statement without a problem, so
> why not?
>
> Gregory Harris
> Los Angeles Information Technology Agency (ITA)
> [EMAIL PROTECTED]
>
>
> >>> [EMAIL PROTECTED] 08/16 10:10 AM >>>
> I'm sorry for the lack of info.
>
> What I am trying to do is keep all of my navigation items in a table.
> When "the powers that be" want to make a change, they will be able to
> go
> to a form to update. When the update happens, I want to have a trigger
> write a .csv file that would be CFinclude in my template. What I am
> wondering is, this worth the trouble?
>
>
> Michael Slatoff
> www.slatoff.com
>
>
> -----Original Message-----
> From: "Gregory Harris" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Date: Wed, 16 Aug 2000 09:40:00 -0700
> Subject: Re: SQL Trigger vs. Stored Procdure
>
> > Could you be a little more specific about what you are trying to do?
> > It sounds like a stored procedure and/or a cursor might be the better
> > and faster way out of what you're doing. Why write to a .csv file?
> > Let me know what you're doing and I'll help ya use the right tools
> for
> > the right job!
> >
> > Gregory Harris
> > Los Angeles Information Technology Agency (ITA)
> > [EMAIL PROTECTED]
> >
> >
> > >>> [EMAIL PROTECTED] 08/16 9:29 AM >>>
> > I am considering using a trigger to write .csv file when a column
> > changes. I will then include that file and use it to loop over.
> >
> > The question is...
> >
> > Is this more efficient or less efficient than using a cached query?
> >
> > Michael Slatoff
> > www.slatoff.com
> >
> >
> >
> -----------------------------------------------------------------------
> > -------
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> > or send a message to [EMAIL PROTECTED] with
> > 'unsubscribe' in the body.
> >
> >
> -----------------------------------------------------------------------
> > -------
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> > or send a message to [EMAIL PROTECTED] with
> > 'unsubscribe' in the body.
>
>
> -----------------------------------------------------------------------
> -------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>
> -----------------------------------------------------------------------
> -------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
