CFMX fails to respond under high load with IIS5
Gentle peoples, We still have this problem .. CFMX crashing when it's being worked. thought it was wddx, but it's not wddx .. see http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7threadid=586790 http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7threadid=586790 for reference but in short .. If you fill up the activeHandlerThreads to max under IIS then you are guaranteed to crash the server.. create a page that takes some time to return results .. nothing big .. say 900ms or so.. and hit it as fast as you can.. have cfstat running and watch it come down .. This is not very good.. The server listening on port 8500 (native http server) still purrs. so it's as if IIS / CFMX communication is failing .. can someone else please verfiy this .. what about settings, should we put the activeHandlerThreads to up above a few thousand ? cheers -Original Message- From: Buckland, Ramon [mailto:[EMAIL PROTECTED] Sent: Friday, 21 March 2003 5:40 PM To: CF-Talk Subject: RE: CFMX crashes with high load on cfwddx Thanks Joe, I've googled and searched a good deal, and only found this relevant one http://www.houseoffusion.com/cf_lists/cache/4/19/19054.htm http://www.houseoffusion.com/cf_lists/cache/4/19/19054.htm Is this it ? As far as I can see, what i am experiencing is very simlar, though slightly worse as this actually stops the server from responding altogether not poor performance, rather no performance ;). bit of an opener for Denial of Service attacks no ? ie: If I know a webserver uses a cfwddx and runs CFMX then .. a constant hit, and down it comes. As an example, one of the pages being converted from 4.5 to MX has 3 CFWDDX calls on the one page. I only have to generate a burst of 3-5 seconds on a freshly rebooted server and MX dies. If there is no fix, we are a bit worried about this as the site has over 250 references to cfwddx (was a fundamental design to the site). ?help :-) -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Friday, 21 March 2003 4:15 PM To: CF-Talk Subject: RE: CFMX crashes with high load on cfwddx Found I can bring down our MX server where cfwddx is used. This is a known problem, i am not sure if MM is doing anything about it. Some MM folks here might be able to answer the status on the cfwddx issue. Joe Eugene -Original Message- From: Buckland, Ramon [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 8:31 PM To: CF-Talk Subject: CFMX crashes with high load on cfwddx Hi, Found I can bring down our MX server where cfwddx is used. In a nut shell, obtain wddx string and convert it. cfwddx action=WDDX2CFML input=#wddxPacket# output=st_RS We use WDDX all over the site as our data layer by retreiving through cfhttp. I tested the cfhttp connections but it all came down to this example. (no cfhttp at all) - cfset wddxPacket = wddxPacket version='1.0'header/datastructvar name='STATUS'string1/string/varvar name='RETURNCODE'stringno_db/string/var/struct/data/wd dxPacket cfwddx action=WDDX2CFML input=#wddxPacket# output=st_RS - Put that in a cfm file and ... Stress testing pages by holding down ,CTRL-R in a browser (IE) the server stops resonding. + From a fresh restart it takes about 5 minutes to bring the server down + From a page with many wddx conversions, I am able to bring the server down in about 5 seconds. * WARNING * This crashes my Dev MX Server on IIS PIII 1.4Ghz , 1.3G RAM IIS5 Win2k All latest patches from MS as of 10 hrs ago. MX Updater 3 Please tell me I can fix this with config changes :-) Symptoms of the crash are: MX stops responding, IIS keeps purring Restart MX a few times and eventually, IIS stops as well (I even had inetinfo hang and not die until I restarted IIS Admin Service) suggestions ? - NOTICE - This message may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee named above. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient of this message you are hereby notified that you must not use, disseminate, copy it in any form or take any action in reliance on it. If you have received this message in error please delete it and any copies of it and notify CREDIT SUISSE ASSET MANAGEMENT immediately. Any views expressed in this message are those of the individual sender, except where the message specifically states otherwise and the sender is authorized to state them to be the views of CREDIT SUISSE ASSET MANAGEMENT. CREDIT SUISSE GROUP, CREDIT SUISSE FIRST BOSTON, and each legal
RE: Learned something today (Oracle)
Tony, My guess is that there is an index on the orderno field but it is a 'varchar' index (as it should be) because the string you are comparing to is an int, it's probably converting each orderno to int and comparing that way. (I would think the opposite though) so because there is no, 'int' index for that column, then it table scans. just a punting guess. -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 April 2003 8:58 AM To: CF-Talk Subject: Learned something today (Oracle) I couldn't understand why some queries on tables selecting using the primary key (orderno) was taking so long... In this instance the field in the database is a varchar field, but it's holding a numeric value. (Don't ask me why, that's another discussion) If I did the query like this: SELECT FROM orderheader WHERE orderno = 60134445 It took like 40 secs! If I did the query like this: SELECT FROM orderheader WHERE orderno = '60134445' Bam! tiny milliseconds... Like it should be. I never realized that the (lack of) quotes was the problem. What causes this slowdown exactly? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.is300.net The Enthusiast's Home of the Lexus IS300 since 1999 http://www.simplemessageboard.comFree Forum Software for Cold Fusion ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Learned something today (Oracle)
T-SQL is Transact SQL, (it originated from Sybase) Sybase (before they sold their technology to Microsoft to make Microsoft SQL Server) also called their server SQL Server After the sale, Sybase then changed it's name, so to not confuse anyone (potentially) MS-SQL (MSSQL) is of course Microsoft SQL Server and is named such (by others, i don't think Microsoft calls it that) Sybase is still Sybase, but of course has the products ASE and ASA (Adaptive Server Enterprise and .. .. Anywhere) and T-SQL in Access .. I think not ;) -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 April 2003 9:38 AM To: CF-Talk Subject: Re: Learned something today (Oracle) Hey Joe...what's MS-SQL?? Access and SQL Server both use T-SQL or is theMS throwing me? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Joe Eugene [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 3:27 PM Subject: RE: Learned something today (Oracle) They must be single-quotes. (guess you weren't paying attn in SQL 101 ;) J/K of course. I dont think i mentioned Oracle or any DB for that matter :) Different DB's have variations in SQL.. T-SQL for MS-SQL , PL-SQL for Oracle etc. Access you can use double quotes... All String(char/varchar) fields in the query should have single/double quotes. Perhaps you didnt read single/double :) Joe Eugene -Original Message- From: Ruggiero, Kevin D [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 6:15 PM To: CF-Talk Subject: RE: Learned something today (Oracle) All String(char/varchar) fields in the query should have single/double quotes. This is something you learn in SQL 101. To clarify- in Oracle if you put double-quotes around a value that you're matching to a String field (char/varchar), it'll come back with an error. They must be single-quotes. (guess you weren't paying attn in SQL 101 ;) J/K of course. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cookies and browser launch methods
Bryan, The tricky detail in your scenario is the non-persistent cookie. (See note at bottom for details on persistant/non persist cookies) Now, when you launch a New browser via CTRL+N, it gets a copy of ALL the vars in memory at that time from the original (including your non persistant cookie). However, when you launch a new browser via the link, it will open up a new instance in it's own memory space and thus does not have the cookie existing. The reason for the 'Taskbar' 2nd browser not running in the same memory space as the first two is probably due to the little tick box on the shortcut which says 'Run in seperate memory space'. (Win2k, if it's not Win2k .. then ask Microsoft :-) If we wanted a web application to be able to have mulitple logins from the same workstation, I would use a seperate cookie name. side note As you know, when the cookie is persistent, it is stored on disk, for all and any instances of that browser to see. So if you closed a browser (and the cookie didn't expire, and the session didn't expire) and opened a new browser within the session/cookie timeframe, then you will of course get the existing session. /side note hope that helps, I may be off is some places (all ?) but from what i can tell and my experience this fits the bill. cheers Ramon Buckland -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 April 2003 8:53 AM To: CF-Talk Subject: Cookies and browser launch methods Hey All, I've just bumped into a situation I haven't seen before and am wondering if anyone can explain why this happens. The Situation: A site that uses a sessions table in the DB and stores the session ID in a non-persistent cookie once the user logs in. The site is colour coded based on the user's group. If I open a browser and login as a user of group A and then use CTRL+N to launch a new window and login as a user of group B, the second login logs me in as the first user. Now that's not odd, because the cookie's name is the same no matter what user group, so what happens when I log in as the second user is the security routine is bypassed (because the cookie already exists from the first user login) and the app continues as if the first user was logged in. Now for the weirdness. If I do the same as above EXCEPT I don't use CTRL+N to open a new windowI use the IE icon in my taskbar. When I do that and log in, I do get logged in as a user of group B (different colour scheme shows). So what is the difference where cookies are concerned when launching a new window via CTRL+N or from the taskbar? Clearly there is some sort of seperation when launching from the taskbar, so if anyone can explain it (and provide a solution) that would be great. I could of course have different cookie names for different user groups (which I may do anyway), but I'd really like to understand what's going on. BTW this has happened in IE 5.5 and 6 TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Session state / cookies within frame???
Hi Costas, IE if told to accept a cookie, will accept it from whereever it comes (banner ads)(think doubleclick.com) frames .. Only thing I can think of is that they are actually pulling your content from there server via a cfhttp (or lang equivalent) and pulling your content into a local frame of theirs is it a standard FrameSet with your URL in the src ? -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 April 2003 11:23 AM To: CF-Talk Subject: Session state / cookies within frame??? Just noticed that a client of our wants our site within a frame from their own site. Normally, cf sets cookies on the client with the site information. We already disallow clients who block cookies (Flame on...), but I don't understand why IE disallows cookies from cross site frames. I'm now somehow tasked with appending cfid and cftoken to every hyperlink, every javascript, every form tag, and every cflocation tag. Argh. Anyone care to enlighten me why this is so? Thanks muchly! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Load Tester
The all so popular tool wget wget http://somesit/somepage wget --help man wget HttpUnit is good. Java Based.. but you want commandline.. here are some suggestions.. http://www.softwareqatest.com/qatweb1.html#FUNC -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, 28 March 2003 10:29 AM To: CF-Talk Subject: Load Tester One of my projects is getting ready to go into production, and the client is suddenly requesting that we do load testing in the production environment in addition to the testing we've already done pre-production (which was on the very same machine). Basically, all I need is some quick numbers to demonstrate that the full testing we already did is still valid down at the hosting facility, without requiring another beastly machine to drive the testing program. Here's the requirements, which are pretty nonflexible: It has to be linux/unix based, command line driven, free and fast. Features are not a high requirement, as long as it can simulate a LOT of users, can take a specific URL or list of URLs to check, and can give the stats back in a reasonably useful format. Anyone have any recomendations for such a program? I know there are a million out there, but I've never used anything as quick and dirty as I need, and I don't have much time to spend looking. much thanks, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.463 / Virus Database: 262 - Release Date: 3/17/2003 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: application.cfm
I beleive so, but just to be good, put a comment in there eg: !--- this is blank to override parent application.cfm in ../ --- -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 March 2003 12:31 PM To: CF-Talk Subject: application.cfm I think I may be stating the obvious here but just checking. I have an app that has an application.cfm file with various settings. I have another app in a sub-directory under that but I don't want it to be the subject of the settings in application.cfm. I assume I can just create a blank or empty application.cfm file to override the other one. Is a blank application.cfm file OK? ** Kevin Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ** ** ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ** ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Weird SQL problem in CF
You may find it has to do with the Locale / Number format of the windows settings of the server. Either SQL Server or the IIS Server. In Win2k it's the 'Regional Settings' in control panel. Taks a look in there (compare to dev box). -Original Message- From: Parker, Kevin [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 March 2003 12:52 PM To: CF-Talk Subject: Weird SQL problem in CF I have a weird problem with a pro bono job I'm doing and hope someone has a clue please. The app works fine on my dev box but when deployed to the production box has a strange problem with numerical fields. Its running CF4.5 with SQL Server 7. All numerical fields are being returned in the format 99,999.00 - notwithstanding the problem, applying NumberFormat fixes it but that doesn't actually solve the problem as to why they are being returned this way. Unfortunately applying NumberFormat to numbers used in queries and lists really screws with the application. The other interesting effect is that if the app is doing a query to a field with an ID greater than 999 it falls over because of the comma inserted into the number. For example doing a query to row 16123 return row 16 not row 16123, because the query string displays the row ID as 16,123.00. Any clues please. ** Kevin Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ** ** ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ** ** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Sybase CF
We use Sybase ASE12.5 For CF5 and below, use the native Sybase ODBC Driver you get with the server. fro CFMX, it has a native Sybase driver. (JDBC based) use that -Original Message- From: Jim Gurfein [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 March 2003 9:13 AM To: CF-Talk Subject: Sybase CF Hi List, Does anyone have any experience in remotely connecting to a Sybase Adaptive Server Anywhere 6.03 with CF? We have a project that would download some files from a remote server running this. Is ODBC an issue? Can we connect with SQL ODBC? Any help would be greatly appreciated. Sincerely yours, Jim Gurfein President, CEO RestaurantRow.com, Inc. http://www.restaurantrow.com 914.921.3200 ext 101 914.921.9190 fax ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: css, dhtml question
Barney, I worked on a web application once that worked (and looked) almost identical to what you have there. We used DHTML (DynAPI a JS Library) and it gave height's etc of the DIV's after content had been set.. thus being able to put footers at the bottom. my point, yes it can be done, if DynAPI had the numbers available to see then the browser has them.. take a look in the DynAPI library and see how they did it. specifically the setHTML() function somewher (been about 2 years sorry) -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 March 2003 6:11 AM To: CF-Talk Subject: RE: OT: css, dhtml question Perhaps a better explaination is in order. The app is internal for an IE5.5+ only audience. It's quite visually complex, and I'm trying to keep the number of page loads down as the presentation changes as much as possible. I have a base page set up like this: +---+ | | +---+---+---+ | | | | | | | | | | | | | | | | | | | | +---+---+---+ | | +---+ The top 4 content areas all have variable content, while the footer is static. As well, the top 4 areas might not all be there, and they might be added or removed client-side. This is all working just dandy using absolute positioning and hiding stuff. However, I need to slap that footer bar at the bottom, and I need it to start below the other content areas (no overlap). I can't figure out a good way to do that, because I don't know how tall the middle 3 areas are (if they are present) until the client renders them. I might well be pursueing a pipe-dream, in which case I'll find another way, but it seems like this should be possible. thanks, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.671.8708 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 10:53 AM To: CF-Talk Subject: Re: OT: css, dhtml question Personally - I handle footers in .cfm includes.. I find it much easier - and simply it includes it at the end of the code. So on shorter and longer pages it simply displays at end. If you needed to actually attach a footer to the bottom of the browser - something like div id=FooterAbs style=position: absolute; bottom: 0px; z-index: 300; would work. I added z-index more for demonstration - The issue is - that you can overalp content. Unlike using an include - that will put it at the bottom no matter what - you will need to scroll to get content beyone viewable screen -but footer will hang on to the bottom edge. Use it carefully because there are almost always some trouble spots. IF your footer can overlap content - not a biggie. In one case I used it - I assigned z-index of -100 ( which also has it's own bugs on browser versions) so on shorter page content the footer didn't interrupt. hope that helps jay miller Barney Boisvert wrote: Totally unrelated, but on the same topic. How might I go about putting a footer bar at the bottom of my page using CSS, rather than a table. I've had no problems with topbars, sidebars (either side) and the main content pane(s), but I can't get stuff to sit at the bottom of the page correctly. I tried 'bottom' (complementing top) but it seems to be tied to the browser's size, not the page's size, which doesn't work if the page scrolls, at least on IE6. Use JS to set it dynamically? footerbar.style.top = Math.max(menubar.style.height, contentpane.style.height) + topbar.style.height; that seems like a horrible way to do it to me. barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.671.8708 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: charlie griefer [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 10:18 AM To: CF-Talk Subject: Re: OT: css, dhtml question may want to give the div class=sidebar a width... it might defined in the 'sidebar' class in the .css...i was too lazy to look :) charlie Mark A. Kruger - CFG writes: Can someone give me the quick and dirty answer on why this page doesn't render correctly in IE? http://www.thelifegate.net/Pages/ClassReg.asp thanks! -mk ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all
RE: Array of Queries and CFOutput
Try saving the queries out of the array if you need to use cfloop /cfoutput. (Just a thought) cfset qry_1 = QueryAry[1] -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Saturday, 22 March 2003 3:19 AM To: CF-Talk Subject: RE: Array of Queries and CFOutput I'm guessing cfoutput query= doesn't evaluate the string correctly. You have already found a workaround though, just don't use output query=. Use the wishform to log a bug for this. == = Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 9:53 AM To: CF-Talk Subject: Array of Queries and CFOutput I don't know if this is a bug, undocumented feature or correct behavior? But has anybody run into this before? I have some code such as this in a CFC creating an array of queries. !--- *** Pseudo code example *** --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion MX Still crashing after updater. *pulling hair out *
Have you got any CFWDDX calls in the site ? Just a thought given our perils. See thread on cfwddx issues watch the wrap... http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid=22567forumid=4refresh=0 :-) We too use an SQL server but my exhaustive tests came up negative to any issues with SQL Server alone and MX. -Original Message- From: Ezine [mailto:[EMAIL PROTECTED] Sent: Sunday, 23 March 2003 8:56 AM To: CF-Talk Subject: RE: ColdFusion MX Still crashing after updater. *pulling hair out* Thanks for your response Jim LOL, I know..definitely odd.. I appreciate you responding. there are no CFX tags at all.. The only outside resource it uses is the Database. It also uses some of the CGI variables and verifies they are not null(or a zero length string) before using them... If I check the CGI variable Http_host several times.. is it going to cause DLLHOST to shoot up? Perhaps DLLHOST is providing that information to JRUN?.. Is there any way that that request that is running behind the scenes.. could be how CFMX stores a cached query? Just a thought.. Recent news: I removed the CFFORM tag in one page on the application.. and I am now relying on the ColdFusion isnumeric() function.. to test and make sure that the value is numeric. It seems to be running better.. It was definitely causing the NULL Pointer JVM error.. I have since(removing it[cfform]).. not seen any of the java.lang.NullPointer errors in the exception.log file. That's good news at least.. and.. at least it is now stable.. Still.. DLLHOST shoots up.. now and then.. but it doesn't hold the processor at 100% for several minutes like it did yesterday(causing the CF overload). Perhaps the CFFORM tag has some problems? Thanks again -Zine -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Saturday, March 22, 2003 3:28 PM To: CF-Talk Subject: RE: ColdFusion MX Still crashing after updater. *pulling hair out* -Original Message- From: Ezine [mailto:[EMAIL PROTECTED] Sent: Saturday, March 22, 2003 2:39 AM To: CF-Talk Subject: ColdFusion MX Still crashing after updater. *pulling hair out* Coldfusion is set to time out all requests after 9 milliseconds(90 seconds).. and yet..iistracer is reporting scripts running for a couple of hours.. during that time.. DLLHOST jumps around.. and Are you calling any external objects? CF can only timeout a thread/request that it has control over - if it's given control of the thread to a another source (database, COM, CFX, etc) then it must wait until that source returns control to it before it can time out the thread. That fact that CF isn't timing out leads me to believe that it not in control (or that it's just plain toast - but since you say that JRUN is still queueing requests it seems to be working). Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX crashes with high load on cfwddx
Hi, Found I can bring down our MX server where cfwddx is used. In a nut shell, obtain wddx string and convert it. cfwddx action=WDDX2CFML input=#wddxPacket# output=st_RS We use WDDX all over the site as our data layer by retreiving through cfhttp. I tested the cfhttp connections but it all came down to this example. (no cfhttp at all) - cfset wddxPacket = wddxPacket version='1.0'header/datastructvar name='STATUS'string1/string/varvar name='RETURNCODE'stringno_db/string/var/struct/data/wddxPacket cfwddx action=WDDX2CFML input=#wddxPacket# output=st_RS - Put that in a cfm file and ... Stress testing pages by holding down ,CTRL-R in a browser (IE) the server stops resonding. + From a fresh restart it takes about 5 minutes to bring the server down + From a page with many wddx conversions, I am able to bring the server down in about 5 seconds. * WARNING * This crashes my Dev MX Server on IIS PIII 1.4Ghz , 1.3G RAM IIS5 Win2k All latest patches from MS as of 10 hrs ago. MX Updater 3 Please tell me I can fix this with config changes :-) Symptoms of the crash are: MX stops responding, IIS keeps purring Restart MX a few times and eventually, IIS stops as well (I even had inetinfo hang and not die until I restarted IIS Admin Service) suggestions ? - NOTICE - This message may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee named above. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient of this message you are hereby notified that you must not use, disseminate, copy it in any form or take any action in reliance on it. If you have received this message in error please delete it and any copies of it and notify CREDIT SUISSE ASSET MANAGEMENT immediately. Any views expressed in this message are those of the individual sender, except where the message specifically states otherwise and the sender is authorized to state them to be the views of CREDIT SUISSE ASSET MANAGEMENT. CREDIT SUISSE GROUP, CREDIT SUISSE FIRST BOSTON, and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX crashes with high load on cfwddx
Thanks Joe, I've googled and searched a good deal, and only found this relevant one http://www.houseoffusion.com/cf_lists/cache/4/19/19054.htm Is this it ? As far as I can see, what i am experiencing is very simlar, though slightly worse as this actually stops the server from responding altogether not poor performance, rather no performance ;). bit of an opener for Denial of Service attacks no ? ie: If I know a webserver uses a cfwddx and runs CFMX then .. a constant hit, and down it comes. As an example, one of the pages being converted from 4.5 to MX has 3 CFWDDX calls on the one page. I only have to generate a burst of 3-5 seconds on a freshly rebooted server and MX dies. If there is no fix, we are a bit worried about this as the site has over 250 references to cfwddx (was a fundamental design to the site). ?help :-) -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Friday, 21 March 2003 4:15 PM To: CF-Talk Subject: RE: CFMX crashes with high load on cfwddx Found I can bring down our MX server where cfwddx is used. This is a known problem, i am not sure if MM is doing anything about it. Some MM folks here might be able to answer the status on the cfwddx issue. Joe Eugene -Original Message- From: Buckland, Ramon [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 8:31 PM To: CF-Talk Subject: CFMX crashes with high load on cfwddx Hi, Found I can bring down our MX server where cfwddx is used. In a nut shell, obtain wddx string and convert it. cfwddx action=WDDX2CFML input=#wddxPacket# output=st_RS We use WDDX all over the site as our data layer by retreiving through cfhttp. I tested the cfhttp connections but it all came down to this example. (no cfhttp at all) - cfset wddxPacket = wddxPacket version='1.0'header/datastructvar name='STATUS'string1/string/varvar name='RETURNCODE'stringno_db/string/var/struct/data/wd dxPacket cfwddx action=WDDX2CFML input=#wddxPacket# output=st_RS - Put that in a cfm file and ... Stress testing pages by holding down ,CTRL-R in a browser (IE) the server stops resonding. + From a fresh restart it takes about 5 minutes to bring the server down + From a page with many wddx conversions, I am able to bring the server down in about 5 seconds. * WARNING * This crashes my Dev MX Server on IIS PIII 1.4Ghz , 1.3G RAM IIS5 Win2k All latest patches from MS as of 10 hrs ago. MX Updater 3 Please tell me I can fix this with config changes :-) Symptoms of the crash are: MX stops responding, IIS keeps purring Restart MX a few times and eventually, IIS stops as well (I even had inetinfo hang and not die until I restarted IIS Admin Service) suggestions ? - NOTICE - This message may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee named above. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient of this message you are hereby notified that you must not use, disseminate, copy it in any form or take any action in reliance on it. If you have received this message in error please delete it and any copies of it and notify CREDIT SUISSE ASSET MANAGEMENT immediately. Any views expressed in this message are those of the individual sender, except where the message specifically states otherwise and the sender is authorized to state them to be the views of CREDIT SUISSE ASSET MANAGEMENT. CREDIT SUISSE GROUP, CREDIT SUISSE FIRST BOSTON, and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
bug (maybe) with evaluate() and CFMX
This works in CF4.5 but not in CFMX. (Can't test for CF5) evaulate only takes one 'expression'. You can't combine multiple expressions seperated by ; in one evaluate. It errors in the evaulation (not 'at' the evaluation) stating that it was not expecting the semicolon. This is different to CF4.5 where you could combine multiple expressions. cfscript fff = myNewVar; evaluate('#fff# = 1; #fff#_another = 2;'); WriteOutput(myNewVar = myNewVar brmyNewVar_another = myNewVar_another); /cfscript Anyone seen this before, I was unable to find references to this bug from googling and direct searching at macromedia. - NOTICE - This message may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee named above. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient of this message you are hereby notified that you must not use, disseminate, copy it in any form or take any action in reliance on it. If you have received this message in error please delete it and any copies of it and notify CREDIT SUISSE ASSET MANAGEMENT immediately. Any views expressed in this message are those of the individual sender, except where the message specifically states otherwise and the sender is authorized to state them to be the views of CREDIT SUISSE ASSET MANAGEMENT. CREDIT SUISSE GROUP, CREDIT SUISSE FIRST BOSTON, and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 2 questions: hot keys and barcodes
What kind of commands do you wish to 'force' ? A barcode scanner just acts as a keybord device (depending on what type you get) so if the barcode (depending on the encoding of course) has some 'commands' you want to send to the browser then ... yes it can be done. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 March 2003 1:39 PM To: CF-Talk Subject: 2 questions: hot keys and barcodes Quick check if anyone knows much about the following: Setup a key in Windows to goto a web address...anyone know how? Second, anyone with experience using barcodes in an intranet inventory app...have a question about whether I can force a few commands via barcodes scanned that hold that code...or I am being t fancy? Thanks! Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 2 questions: hot keys and barcodes
Two separate things...one, want to config a f key to open a browser window. Antony answered this, Tried it. Worked with F8. :-) There are programs that do this job for _any_ application if you need to use an F key reserved by the OS or environment. Keyboard listeners/Program launchers.. google for that stuff. Second, we have had no problems doing the barcoding...but question has been raised if we can scan a code, which triggers a javascript event, or the like... Well .. yes, DynAPI (http://dynapi.sourceforge.net/dynapi/) (A DHTML JavaScript API) has a keypress library which can be loaded on it's own. Here it is extracted http://www.scottandrew.com/dhtml/docs/keypress.html (DynAPI is very quiet these days :-) cheers ramon buckland - NOTICE - This message may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee named above. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient of this message you are hereby notified that you must not use, disseminate, copy it in any form or take any action in reliance on it. If you have received this message in error please delete it and any copies of it and notify CREDIT SUISSE ASSET MANAGEMENT immediately. Any views expressed in this message are those of the individual sender, except where the message specifically states otherwise and the sender is authorized to state them to be the views of CREDIT SUISSE ASSET MANAGEMENT. CREDIT SUISSE GROUP, CREDIT SUISSE FIRST BOSTON, and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: textarea line numbering
Ooh I love a challenge, :-) Here you go matthew line numbers next to a scrollable textarea implemented client side using Javascript, onscroll, onkeyup and some mirrors. http://www.thebuckland.com/staging/line_numbers_for_textarea.html -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 March 2003 2:21 PM To: CF-Talk Subject: textarea line numbering I've been exploring the possibility of editing stylesheets online and I'm looking for a way to provide line numbering in a textarea window. Anybody seen anything like this? The best I can come up with is (instead of textarea) using a series of text fields one on top of another each with a number next to them. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: textarea line numbering
Few bugs in that + line numbers 100 + holding down enter key releasing doesn't update the numbers oh .. and it was only tested in IE, i'll check it later with others (NS, Moz, Galeon and Opera) In theory it is DOM compliant. so should be fine. but hey, you get the drift. Wow! That's awesome! I can't believe it works so well! (Wait until I think of something a bit harder...) go for it!, it keeps the mind off of other happenings in the world :-) -Original Message- From: Buckland, Ramon [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 March 2003 5:09 p.m. To: CF-Talk Subject: RE: textarea line numbering Ooh I love a challenge, :-) Here you go matthew line numbers next to a scrollable textarea implemented client side using Javascript, onscroll, onkeyup and some mirrors. http://www.thebuckland.com/staging/line_numbers_for_textarea.html -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 March 2003 2:21 PM To: CF-Talk Subject: textarea line numbering I've been exploring the possibility of editing stylesheets online and I'm looking for a way to provide line numbering in a textarea window. Anybody seen anything like this? The best I can come up with is (instead of textarea) using a series of text fields one on top of another each with a number next to them. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
logic in CFC vs Java CFX
Hi All, I have a Custom CFX Tag written in java (in house) and have wrapped it's access in a CFC. Because there is also some logic in the CFC before it calls the custom tag, should i just ditch the CFC and transfer the logic to the CFX ? Will I gain in performance (yes I am trying to write both but there is actually lot of leg work for this one)? (my understanding is the CFC gets compiled to Java Bytecode) My concern is memory usage and such. The custom tag (Java CFX) scales well handling well over 200 hits per second from varying clients and random data. Is very thread safe. However from my initial development, I can't say the same for the wrapper to the CFX. I managed to lock up the CFMX server with simlilar stress testing to the CFC. The CFC is called via cfinvoke (im moving it to application scope with a cfobject and then inidividual calls to that object) any suggestions, anybody done much work in this area ? cheers - NOTICE - This message may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee named above. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient of this message you are hereby notified that you must not use, disseminate, copy it in any form or take any action in reliance on it. If you have received this message in error please delete it and any copies of it and notify CREDIT SUISSE ASSET MANAGEMENT immediately. Any views expressed in this message are those of the individual sender, except where the message specifically states otherwise and the sender is authorized to state them to be the views of CREDIT SUISSE ASSET MANAGEMENT. CREDIT SUISSE GROUP, CREDIT SUISSE FIRST BOSTON, and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
objects in application memory
We have an application which uses an object in generating page output every request. eg: cfset somevar = myobj.function(param1, param2, param3) I have rewritten it just now as a CFC (originally Java) and plan to invoke it via CFObject. It is generally called upon about 5 times within a page request to do some processing My question is, We will be calling it within the application.cfm so should it be 1) invoked once and loaded into application memory 2) invoked once per session and saved into session memory 3) invoke and use each page request Just wondering if using / storing an object in memory vs invkoing it upon each request has benfits. Dos MX do object caching behind the scenes? Im am assuming depending on Java vs some other type of object .. it should be done differently? Does anyone have any war scars in this area ? What if the CFC was instead a Java Object ? (the current 4.5 site is a Java Object, thread safe and invoked each request) (3 years ago, it was written as a singleton class but CF4.5 didn't like that / didn't seem to work that way so we just made it thread safe.) I know this is broad as Im scoping avenues for the MX way :-) cheers Ramon - NOTICE - This message may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee named above. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient of this message you are hereby notified that you must not use, disseminate, copy it in any form or take any action in reliance on it. If you have received this message in error please delete it and any copies of it and notify CREDIT SUISSE ASSET MANAGEMENT immediately. Any views expressed in this message are those of the individual sender, except where the message specifically states otherwise and the sender is authorized to state them to be the views of CREDIT SUISSE ASSET MANAGEMENT. CREDIT SUISSE GROUP, CREDIT SUISSE FIRST BOSTON, and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF and PhotoShop
Depending on what type of processing you want, you may find the solution in ImageMagick http://www.imagemagick.org/ There is abit of work done with ImageMagick and ColdFusion tags, just google for more info. -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 March 2003 8:35 AM To: CF-Talk Subject: CF and PhotoShop Any of you ever scripted CF to run tasks in PhotoShop? Can it be done? CFExecute and all that. On Win2K? Any pointers on how to do it? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Writing Query Results to a CSV using CFFILE
Wendy, My initial guess is the delay in the CFFILE, disk IO. Try buffering the rows.. Along with this suggestion below you could try converting it to a CFSCRIPT. MX apparently runs CFScript quicker too (I think ? ) Though you would have to write a function for cffile. http://www.macromedia.com/devnet/mx/coldfusion/extreme/cftags_cfscript.html Anyway .. try this (i just wrote it in the email, haven't tested it yet but you will get the drift). maybe play with the buffer a bit (trading system memory (holding X lines to disk IO from CFFILE) eg: cfset int_row_count = 0 cfset buffer_len = 500 cfset outputLine = cfoutput query=online_reg cfset int_row_count = int_row_count + 1 cfset outputLine = outputLine chr(13) #ID#,#FirstName#,#LastName#,#Address1#,#Address2#,#City#,#State#,#Zip# cfif int_row_count eq buffer_len cffile action=append file=#exportFilePath# output='#outputLine#' addnewline=yes cfset outputLine = cfset int_row_count = 0 /cfif /cfoutput !--- output any last lines hanging about --- cfif len(outputLine) gt 0 cffile action=append file=#exportFilePath# output='#outputLine#' addnewline=yes /cfif We had a simlar issue where the server just pushed the content out as a CSV via CFCONTENT We had something like cfoutput query=qry_results cfset csvStuff = csvStuff '#col1','#col2#',... /cfoutput CFHEADER NAME=content-disposition VALUE=attachment;filename=output.csv cfoutput#csvStuff#/cfoutput issue above was we were building our CSV content in a variable (ie, in memory) .. I got our 40min CSV download down to 6 mins (intranet so we don't care) by 'streaming the content out' eg: CFHEADER NAME=content-disposition VALUE=attachment;filename=output.csv cfoutput query=qry_results... /cfoutput hope that helps. -Original Message- From: Wendy Copley [mailto:[EMAIL PROTECTED] Sent: Wednesday, 12 March 2003 9:49 AM To: CF-Talk Subject: Writing Query Results to a CSV using CFFILE Hi All! I've inherited a reporting application that allows users to dump the results of a query into a CSV file (via the CFFILE tag) and either save it or open it. This works pretty well most of the time, but there are some circumstances where the results set is over 150K rows. In those cases it can take 30+ minutes to build the file and my users usually get impatient and close their browsers before it is done building. Does anyone have any ideas about how I can speed up the process of building this file? This is the code used to build the file: cfset export_header=Record ID,FirstName,LastName,Address1,Address2,City,State,Zip !--- export table header --- cfoutput cffile action=write file=#exportFilePath# output=#export_header# addnewline=yes /cfoutput !--- append the search query to the file --- cfoutput query=online_reg cfset outputLine=#ID#,#FirstName#,#LastName#,#Address1#,#Address2#, #City#,#State#,#Zip# cffile action=append file=#exportFilePath# output='#outputLine#' addnewline=yes /cfoutput I've tried building one big variable and appending that all at once instead of appending each record one at a time and that takes about twice the time to execute that this code does. I'm beginning to wonder if CFFILE is the best way to go. Any other ideas? I'm running ColdFusion 4.5. Thanks for any help you can give! ___ Wendy Copley Web Engineer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Writing Query Results to a CSV using CFFILE
Just saw bug in my code re: the location of a newline. change cfset outputLine = outputLine chr(13) #ID#,#FirstName#,#LastName#,#Address1#,#Address2#,#City#,#State#,#Zip# to cfset outputLine = outputLine #ID#,#FirstName#,#LastName#,#Address1#,#Address2#,#City#,#State#,#Zip# chr(13) and the cffiles to cffile action=append file=#exportFilePath# output='#outputLine#' addnewline=no With regards to building the CSV string in memory. As we found, it absolutely killed poor old CF4.5 and thus my solutions was stream it as much as possible. Your issue (since SQL 7 is purring as it should) is CFFILE. As Barney and Dave mentioned, reducing the CFFILE's would be your goal and I would caution holding the whole string in memory as that too produced a bottleneck for us. YMMV. cheers ramon -Original Message- From: Buckland, Ramon [mailto:[EMAIL PROTECTED] Sent: Wednesday, 12 March 2003 10:34 AM To: CF-Talk Subject: RE: Writing Query Results to a CSV using CFFILE Wendy, My initial guess is the delay in the CFFILE, disk IO. Try buffering the rows.. Along with this suggestion below you could try converting it to a CFSCRIPT. MX apparently runs CFScript quicker too (I think ? ) Though you would have to write a function for cffile. http://www.macromedia.com/devnet/mx/coldfusion/extreme/cftags_ cfscript.html Anyway .. try this (i just wrote it in the email, haven't tested it yet but you will get the drift). maybe play with the buffer a bit (trading system memory (holding X lines to disk IO from CFFILE) eg: cfset int_row_count = 0 cfset buffer_len = 500 cfset outputLine = cfoutput query=online_reg cfset int_row_count = int_row_count + 1 cfset outputLine = outputLine chr(13) #ID#,#FirstName#,#LastName#,#Address1#,#Address2#,#City#,#Sta te#,#Zip# cfif int_row_count eq buffer_len cffile action=append file=#exportFilePath# output='#outputLine#' addnewline=yes cfset outputLine = cfset int_row_count = 0 /cfif /cfoutput !--- output any last lines hanging about --- cfif len(outputLine) gt 0 cffile action=append file=#exportFilePath# output='#outputLine#' addnewline=yes /cfif We had a simlar issue where the server just pushed the content out as a CSV via CFCONTENT We had something like cfoutput query=qry_results cfset csvStuff = csvStuff '#col1','#col2#',... /cfoutput CFHEADER NAME=content-disposition VALUE=attachment;filename=output.csv cfoutput#csvStuff#/cfoutput issue above was we were building our CSV content in a variable (ie, in memory) .. I got our 40min CSV download down to 6 mins (intranet so we don't care) by 'streaming the content out' eg: CFHEADER NAME=content-disposition VALUE=attachment;filename=output.csv cfoutput query=qry_results... /cfoutput hope that helps. -Original Message- From: Wendy Copley [mailto:[EMAIL PROTECTED] Sent: Wednesday, 12 March 2003 9:49 AM To: CF-Talk Subject: Writing Query Results to a CSV using CFFILE Hi All! I've inherited a reporting application that allows users to dump the results of a query into a CSV file (via the CFFILE tag) and either save it or open it. This works pretty well most of the time, but there are some circumstances where the results set is over 150K rows. In those cases it can take 30+ minutes to build the file and my users usually get impatient and close their browsers before it is done building. Does anyone have any ideas about how I can speed up the process of building this file? This is the code used to build the file: cfset export_header=Record ID,FirstName,LastName,Address1,Address2,City,State,Zip !--- export table header --- cfoutput cffile action=write file=#exportFilePath# output=#export_header# addnewline=yes /cfoutput !--- append the search query to the file --- cfoutput query=online_reg cfset outputLine=#ID#,#FirstName#,#LastName#,#Address1#,#Address2#, #City#,#State#,#Zip# cffile action=append file=#exportFilePath# output='#outputLine#' addnewline=yes /cfoutput I've tried building one big variable and appending that all at once instead of appending each record one at a time and that takes about twice the time to execute that this code does. I'm beginning to wonder if CFFILE is the best way to go. Any other ideas? I'm running ColdFusion 4.5. Thanks for any help you can give! ___ Wendy Copley Web Engineer [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists
RE: administrator wont open
Sounds like the .cfm{l} file is not registered in Apache to be handled by ColdFusion (CFMX install should have done it) What are the contents of the file if you _do_ save it ? Is it the ColdFusion file ? Does a normal coldfusion page work (not just admin) try a simple .cfm page in the root of the server cfset fff = foobarcfoutput#fff#/cfoutput If normal cfm pages don't work take a look in the httpd.conf file looking for the .cfm extension (should be in there) the httpd.conf file should be/could be located at /etc/httpd/httpd.conf or /etc/apache/httpd.conf -Original Message- From: Juan Nava [mailto:[EMAIL PROTECTED] Sent: Wednesday, 12 March 2003 4:00 PM To: CF-Talk Subject: administrator wont open Hello all. I have recently installed CFMX on Apache 2.0.44 and Apache seems to start fine. All the CF services are running, but I can't seem to open the CF admin page successfully. Instead, I am promped to open or save the cfm file and never get to see the admin page. I am missing something simple. Any suggestions??? Thanks in advance. Juan __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: administrator wont open
Looks like it didn't install properly.. is Apache in a standard location ? Is there two Apache Servers on the box ? One last thing would be to checkfor the existence of 'coldfusion' in the httpd.conf file. Some examples of configs I have seen don't have .cfm mentioned. In this situation I would opt for attempting a reinstall (making sure that you put Coldfusion into the same path, but check the webserver/apache settings as you go. If you want to try an 'patch it up manually' you could (if it doesn't work, i'd reinstall as CFMX should do this and since it didn't I would suspect, as evident, that it's not installed correctly :-) 1) In the httpd.conf file Add the ColdFusion Module stuff as per : Configuring Apache we server on UNIX section in http://ssis.lbcc.cc.ca.us/cfdocs/Installing_ColdFusion_MX/configuring4.html Where the other 'LoadModule' bits are. Not sure if ports would be the same, change the paths as appropriate 2) add a cfm (and cfml handler) .. can't find a 'real' example but it looks like you need to add AddHandler jrun-handler .cfm .cfc .jsp .cfml .jws into the ifmodule ../ifmodule section (just after the commented out 'jrunconfig Errorurl' bit. otherwise, go for reinstall :-) -Original Message- From: Juan Nava [mailto:[EMAIL PROTECTED] Sent: Wednesday, 12 March 2003 3:17 PM To: CF-Talk Subject: administrator wont open If I choose to open it, Dreamweaver opens it successfully but shows a bunch of junk basically. Anyother cfm page on my machine wont open in the browsers. If I save it, its just like moving the index.cfm file from the original folder to whereever I save it. The httpd file contains nothing menitoning cfm. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4