OK, I will try to create a CFX and make a lot of test using MS WebStress to make sure that any result will be always ok. Or only create a CustomTag that do this kind job (I know it's not the best way.) For the CFX I don't know if my boss will allow me to create this kind of code. They don't understand why you need to optimize the application. Anyway.
Thanks! Yanik Lupien -----Message d'origine----- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoy� : Thursday, September 27, 2001 11:22 � : SQL Objet : RE: SQL List Personally, I would try it several different ways and benchmark them to see which is the best use of resources. I agree that SQL cursors are highl y inefficient, but I suspect that they will be more efficient than doing the same thing in the middleware layer (i.e., ColdFusion). As Dean pointed out, even the native SQL 2000 support for this is pretty slow. I've ne ver tried this, so your results may be surprising to everyone - especially me. =B) Be cautious if you create it as a CFX, since it is difficult to get CFX s to multi-thread properly and dangerous to multi-thread them if they don't. Test the thing to death or CFLOCK it to prevent it from multi-threading . To do otherwise will risk the uptime stats on your CF server, the batte ry life of your pager, and the peacefulness of your sleep. =B) |----------------------+----------------------------------------------- ---| |Eric A. Laney |"The right to do something does not mean that | |Systems Engineer |doing it is right." | |LAN Optimization Team | | |Verizon Data Services | | |Voice: 813.978.4404 | William Saf ire| |Pager: 888.985.8519 | | |----------------------+----------------------------------------------- ---| "Yanik Lupien" To: SQL <sql@houseoffusion com> <yanikl@visic cc: .com> Subject: RE: SQL List 2001-09-27 11:08 Please respond to sql Ok. I only have MS SQL 7.0 and Our application is for MS SQL only. I will create a CFX that do this kind of task. Thank! Sorry for my english! Yanik Lupien -----Message d'origine----- De : Dean H. Saxe [mailto:[EMAIL PROTECTED]] Envoy� : Thursday, September 27, 2001 11:03 � : SQL Objet : Re: SQL List Eric, Good suggestion, but its highly inefficient. Apparently SQL Server 2000 has some functionality to allow you to aggre gate column data like that... but beware, its not portable across different RDBMS and I would guess its performance is not so hot. -dhs At 10:16 AM 9/27/01 -0400, [EMAIL PROTECTED] wrote: >The only way I know to get a relational database to output a >comma-delimited list is to use a cursor. > |-------------------+-------------------------------------------------- ---| >|Eric A. Laney |"We have seen too much success to have become | >|Systems Engineer |obsessed with failure." | >|LAN Optimization | | >|Team | | >|Verizon Data | Lyndon B. Johnson (1908-1973)^Quoted in National| >|Services | Review, 31 December 1963| >|Voice: 813.978.4404| | >|Pager: 888.985.8519| | >| | | > |-------------------+-------------------------------------------------- ---| > > > > > > > > "Yanik > > Lupien" To: SQL > <[EMAIL PROTECTED]> > <yanikl@visic cc: > > .com> Subject: SQL > List > > > 2001-09-27 > > 09:46 > > Please > > respond > to > > sql > > > > > > > > > >Hi, > >I have a small question. > >This is my table : > >English French >-------- -------- >Dog Chien >Dog Pitou >Cat Chat >Cat Minou >Animal Animal > >I want something like : Select English, XXXX(French) from table group by >English : to get a list of "French" > >English French >-------- -------- >Dog Chien, Pitou >Cat Chat, Minou >Animal Animal > >It is possible ? > >Yanik Lupien > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
