Re: ColdFusion for Dummies revision - CF5 features... CFSQL
I hope for one that CFSQL supports the DISTINCT statement. Would make those category drop downs a breeze... jon - Original Message - From: "Dave Watts" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 05, 2000 6:03 PM Subject: RE: ColdFusion for Dummies revision - CF5 features Absent good information we've been speculating about the CF5 ability to query a query. It may not be written to emulate anything and to do no more than allow simple look-ups and other low-level ops that are not currently part of the functions toolbox. Has anyone stated that we are getting a full blown inline analyzer? Could be just an expansion of Queryxxx function set. It could be, but they're calling it "CFSQL", so that sounds like SQL statements to me. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion for Dummies revision - CF5 features
| b.. Ability to run queries against existing query result sets (CFSQL). I don't understand the need for that. Couldn't you just run another query? Or is it some sort of performance issue thing since the query is in memory? Since the query is stored in memory (I assume resident only while the page is processing) you would be running your sub queries against memory. This would be a big time performance boost over running traditional queries because of the difference between the speed of memory access vs. db access. Not to be a wet blanket, but this isn't necessarily so. The problem here is that CF doesn't currently execute SQL statements. All it does is pass those as strings to the database, which executes them and returns the appropriate recordsets. Now the people who make the databases spend an awful lot of time (and money) optimizing query execution. They take advantage of indexes, alternate possible paths, bind parameters, and other stuff to make SQL run very fast. When Allaire puts in an SQL analyzer, it's unlikely that it'll match the best efforts of Oracle and Microsoft in SQL execution efficiency. To have a chance at making this work, Allaire may have to incorporate a complete in-memory database, in my opinion, which will make the base product more complex and potentially more fragile. Just a thought. I could be wrong. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion for Dummies revision - CF5 features
[Lots of message chaff on the list lately, can't find new messages amidst all the echoed old posts] From: "Dave Watts" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 20:05 Subject: RE: ColdFusion for Dummies revision - CF5 features When Allaire puts in an SQL analyzer, it's unlikely that it'll match the best efforts of Oracle and Microsoft in SQL execution efficiency. To have a chance at making this work, Allaire may have to incorporate a complete in-memory database, in my opinion, which will make the base product more complex and potentially more fragile. Absent good information we've been speculating about the CF5 ability to query a query. It may not be written to emulate anything and to do no more than allow simple look-ups and other low-level ops that are not currently part of the functions toolbox. Has anyone stated that we are getting a full blown inline analyzer? Could be just an expansion of Queryxxx function set. Pan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion for Dummies revision - CF5 features
| b.. Ability to run queries against existing query result sets (CFSQL). I don't understand the need for that. Couldn't you just run another query? Or is it some sort of performance issue thing since the query is in memory? Since the query is stored in memory (I assume resident only while the page is processing) you would be running your sub queries against memory. This would be a big time performance boost over running traditional queries because of the difference between the speed of memory access vs. db access. Not to be a wet blanket, but this isn't necessarily so. The problem here is that CF doesn't currently execute SQL statements. All it does is pass those as strings to the database, which executes them and returns the appropriate recordsets. Now the people who make the databases spend an awful lot of time (and money) optimizing query execution. They take advantage of indexes, alternate possible paths, bind parameters, and other stuff to make SQL run very fast. When Allaire puts in an SQL analyzer, it's unlikely that it'll match the best efforts of Oracle and Microsoft in SQL execution efficiency. There is no disputing that, as there is no subsitiute for a fully optimized and well written query, but there are times that it would be nice to be able to query or resort the data set without returning to database engine. Querying against queries temporarily stored in memory (depending on Allaire's strategy) should be much faster than making another call to the db to return a partial record. In theory, which as we all know rarely emulates real life, querying a query should be faster than making an additional call to the database. At this point I guess it is up to the implementation to prove or disprove. To have a chance at making this work, Allaire may have to incorporate a complete in-memory database, in my opinion, which will make the base product more complex and potentially more fragile. Placing the entire database in memory definelty has its advantages and disadvantages. Just a thought. I could be wrong. The temperature in hell just dropped a couple of degrees ;) Cheers, Duane "The internet, they have that on computers now you know.": Homer Simpson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion for Dummies revision - CF5 features
Absent good information we've been speculating about the CF5 ability to query a query. It may not be written to emulate anything and to do no more than allow simple look-ups and other low-level ops that are not currently part of the functions toolbox. Has anyone stated that we are getting a full blown inline analyzer? Could be just an expansion of Queryxxx function set. It could be, but they're calling it "CFSQL", so that sounds like SQL statements to me. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion for Dummies revision - CF5 features
Taken from CFVault's summary of Allaire DevCon: [http://www.cfvault.com/index.cfm/mode/DisplayContent/ContentElementID/64/El ementPage/2] CF 5.0 will be built on the existing codebase, and released during the first half of 2001. It is NOT part of the Pharaoh initiative, the next generation of Allaire application server platform. Here are some of the CF 5.0 features: a.. User defined functions and functions libraries. b.. Ability to run queries against existing query result sets (CFSQL). c.. Partial page output. d.. Server side graphic engine. - Original Message - From: "Angél Stewart" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 7:56 AM Subject: RE: ColdFusion for Dummies revision Ok..did I miss something? Where is the featureset for Coldfusion 5.0 listed? :-) -Gel -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] John: Make sure you include user defined functions because that is the singlemost important (in my opinion) new feature with 5.0. Also, you might want to go over briefly application frameworks like fusebox and any other known ways for newbies to structure CF. Best Regards, ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion for Dummies revision - CF5 features
| b.. Ability to run queries against existing query result sets (CFSQL). I don't understand the need for that. Couldn't you just run another query? Or is it some sort of performance issue thing since the query is in memory? Todd Ashworth - Original Message - From: "Alex Aguilar" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:10 PM Subject: Re: ColdFusion for Dummies revision - CF5 features | Taken from CFVault's summary of Allaire DevCon: | [http://www.cfvault.com/index.cfm/mode/DisplayContent/ContentElementID/64/El | ementPage/2] | | CF 5.0 will be built on the existing codebase, and released during the first | half of 2001. It is NOT part of the Pharaoh initiative, the next generation | of Allaire application server platform. | | Here are some of the CF 5.0 features: | a.. User defined functions and functions libraries. | b.. Ability to run queries against existing query result sets (CFSQL). | c.. Partial page output. | d.. Server side graphic engine. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion for Dummies revision - CF5 features
O! This makes me very happy, and will certainly make the other developers happy as well. We've been lamenting the lack of UDFs for a good while. Thanks for the pointer! -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Alex Aguilar [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, December 04, 2000 1:38 PM Subject: Re: ColdFusion for Dummies revision - CF5 features Taken from CFVault's summary of Allaire DevCon: [http://www.cfvault.com/index.cfm/mode/DisplayContent/ContentElementID/64/E l ementPage/2] CF 5.0 will be built on the existing codebase, and released during the first half of 2001. It is NOT part of the Pharaoh initiative, the next generation of Allaire application server platform. Here are some of the CF 5.0 features: a.. User defined functions and functions libraries. b.. Ability to run queries against existing query result sets (CFSQL). c.. Partial page output. d.. Server side graphic engine. - Original Message - From: "Angél Stewart" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 7:56 AM Subject: RE: ColdFusion for Dummies revision Ok..did I miss something? Where is the featureset for Coldfusion 5.0 listed? :-) -Gel -Original Message- From: Greg Wolfinger [mailto:[EMAIL PROTECTED]] John: Make sure you include user defined functions because that is the singlemost important (in my opinion) new feature with 5.0. Also, you might want to go over briefly application frameworks like fusebox and any other known ways for newbies to structure CF. Best Regards, ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion for Dummies revision - CF5 features
From: "Todd Ashworth" [EMAIL PROTECTED] Subject: Re: ColdFusion for Dummies revision - CF5 features | b.. Ability to run queries against existing query result sets (CFSQL). I don't understand the need for that. Couldn't you just run another query? Or is it some sort of performance issue thing since the query is in memory? frex; the query returned by CFPOP ... being able to apply sql aginst that query would be plus-plus-good vs, the current need to do all sorts of monkeys-squatting-on-lava scripting to accomplish certain data manipulatons and handling. Pan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion for Dummies revision - CF5 features
Well that means you could pass a results in a WDDX recordset as a form variable or even session or whatever storage. Then convert it to a query and query the results again?! Neil - Original Message - From: "Todd Ashworth" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 1:50 PM Subject: Re: ColdFusion for Dummies revision - CF5 features | b.. Ability to run queries against existing query result sets (CFSQL). I don't understand the need for that. Couldn't you just run another query? Or is it some sort of performance issue thing since the query is in memory? Todd Ashworth - Original Message - From: "Alex Aguilar" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:10 PM Subject: Re: ColdFusion for Dummies revision - CF5 features | Taken from CFVault's summary of Allaire DevCon: | [http://www.cfvault.com/index.cfm/mode/DisplayContent/ContentElementID/64/El | ementPage/2] | | CF 5.0 will be built on the existing codebase, and released during the first | half of 2001. It is NOT part of the Pharaoh initiative, the next generation | of Allaire application server platform. | | Here are some of the CF 5.0 features: | a.. User defined functions and functions libraries. | b.. Ability to run queries against existing query result sets (CFSQL). | c.. Partial page output. | d.. Server side graphic engine. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion for Dummies revision - CF5 features
| b.. Ability to run queries against existing query result sets (CFSQL). I don't understand the need for that. Couldn't you just run another query? Or is it some sort of performance issue thing since the query is in memory? Since the query is stored in memory (I assume resident only while the page is processing) you would be running your sub queries against memory. This would be a big time performance boost over running traditional queries because of the difference between the speed of memory access vs. db access. Hope this makes sense. Cheers, Duane Boudreau Director of Web Technologies Ektron, Inc. Todd Ashworth - Original Message - From: "Alex Aguilar" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:10 PM Subject: Re: ColdFusion for Dummies revision - CF5 features | Taken from CFVault's summary of Allaire DevCon: | [http://www.cfvault.com/index.cfm/mode/DisplayContent/ContentEleme ntID/64/El | ementPage/2] | | CF 5.0 will be built on the existing codebase, and released during the first | half of 2001. It is NOT part of the Pharaoh initiative, the next generation | of Allaire application server platform. | | Here are some of the CF 5.0 features: | a.. User defined functions and functions libraries. | b.. Ability to run queries against existing query result sets (CFSQL). | c.. Partial page output. | d.. Server side graphic engine. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion for Dummies revision - CF5 features
Yeah, you could just run another query, but if you already have a query and you want to pull a subset of it, it does save resources to run a subquery off of what you already store. So in responce to your question: "Yeah". -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Todd Ashworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Monday, December 04, 2000 3:34 PM Subject: Re: ColdFusion for Dummies revision - CF5 features | b.. Ability to run queries against existing query result sets (CFSQL). I don't understand the need for that. Couldn't you just run another query? Or is it some sort of performance issue thing since the query is in memory? Todd Ashworth - Original Message - From: "Alex Aguilar" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:10 PM Subject: Re: ColdFusion for Dummies revision - CF5 features | Taken from CFVault's summary of Allaire DevCon: | [http://www.cfvault.com/index.cfm/mode/DisplayContent/ContentElementID/64/E l | ementPage/2] | | CF 5.0 will be built on the existing codebase, and released during the first | half of 2001. It is NOT part of the Pharaoh initiative, the next generation | of Allaire application server platform. | | Here are some of the CF 5.0 features: | a.. User defined functions and functions libraries. | b.. Ability to run queries against existing query result sets (CFSQL). | c.. Partial page output. | d.. Server side graphic engine. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion for Dummies revision - CF5 features
It will also be nice to be able to sort the data on a page, or even on a multi-page data set without going back to the database server. At 12:39 PM 12/4/00 -0800, pan wrote: From: "Todd Ashworth" [EMAIL PROTECTED] Subject: Re: ColdFusion for Dummies revision - CF5 features | b.. Ability to run queries against existing query result sets (CFSQL). I don't understand the need for that. Couldn't you just run another query? Or is it some sort of performance issue thing since the query is in memory? frex; the query returned by CFPOP ... being able to apply sql aginst that query would be plus-plus-good vs, the current need to do all sorts of monkeys-squatting-on-lava scripting to accomplish certain data manipulatons and handling. Pan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ColdFusion for Dummies revision - CF5 features
Since the query is stored in memory (I assume resident only while the page is processing) you would be running your sub queries against memory. This would be a big time performance boost over running traditional queries because of the difference between the speed of memory access vs. db access. cfquery name='thisquery" dsn= /cfquery cfset session.thisQuery = thisQuery Query is in memory, faster than any I/O and it also seems faster than a cached query. In a situation where a query is generated and then there is a relatively great amount of subsequent processing and handling of the data contained in the query this method works wonders for page and calculation speed. Data refresh is simple (rerun query) without need to watch cachedwithin.etc. time settings. Only difficulty is not being able to apply sql against the session scoped query. Functions can handle (though not easily) most manipulations. Of course, cfid cftoken are necessary with session - not needed with cached. Pan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
