Re: Problem with cf executing stored procedures
On Thursday 11 January 2007 10:06, Simon Whittaker wrote: > I hope you can help us with a problem we are experiencing with execution of > stored procedures from coldfusion pages. Stored procedures are running very > slowly only when executed from cf pages, when they're run in the SQL 2000 > query analyser they run in sometimes less than a second but when run from Do the procs return lots of data ? If so, CF will be retriving them all at once, the query analyser maybe not. -- Tom Chiverton Helping to centrally foster efficient market-growth This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266363 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem with cf executing stored procedures
Simon, >From your description if each server is executing nominally on each end, it would suggest your issue exists in the network layer. Have you talked to your network admin to ask him to perform a round trip from server to server to see how long and how many "hops" are occuring to get from server to server? If the server are both internal, I would examine what is going on with your router or switch. I would examine network drivers on the Network cards. Are you crossing the DMZ to get from system to system? Are there software firewalls or packet sniffers delaying your transmissions? These questions are rhetoric and I do not need the answers to, but questions you need to ask yourself and team if you can find out how long it takes to get a data packet from one location to another? Teddy On 1/11/07, Simon Whittaker <[EMAIL PROTECTED]> wrote: > > All, > > I hope you can help us with a problem we are experiencing with execution > of > stored procedures from coldfusion pages. Stored procedures are running > very > slowly only when executed from cf pages, when they're run in the SQL 2000 > query analyser they run in sometimes less than a second but when run from > coldfusion they can take upwards of 60-80seconds seconds (which seems > ridiculous). The timer in the debugging states that the sp has taken < > 10ms > to run but when we put a time round it we get a time of the 60-80 seconds. > I am wondering if there is something I have missed in the cf > administrator or a hot fix I have missed or something wrong with my SQL > setup which is causing this huge delay? > > CF version is 7.0.2.142559 > SQL is Sql server 2000 > > All advice appreciated > > Cheers > > S > > > ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266222 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem with cf executing stored procedures
All, I hope you can help us with a problem we are experiencing with execution of stored procedures from coldfusion pages. Stored procedures are running very slowly only when executed from cf pages, when they're run in the SQL 2000 query analyser they run in sometimes less than a second but when run from coldfusion they can take upwards of 60-80seconds seconds (which seems ridiculous). The timer in the debugging states that the sp has taken < 10ms to run but when we put a time round it we get a time of the 60-80 seconds. I am wondering if there is something I have missed in the cf administrator or a hot fix I have missed or something wrong with my SQL setup which is causing this huge delay? CF version is 7.0.2.142559 SQL is Sql server 2000 All advice appreciated Cheers S ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266217 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF executing stored procedures?
I have come across an interesting occurrence where CF mysteriously started to fail on a Stored procedure. The storedProc was working fine for a while and now it doesn't. The storedProc is executed in a cfquery (there seems to be an issue with the cfstoredproc tag and paraming timestamps), anyways it executes in SQL QUERY ANALYZER just fine. The SQL statement is good and generates no errors. Sometimes CF will leave an open pipe to the db server and lock up the database for 45 minutes. Anyone have any suggestions? Environment: NT 4.0 sp5 CF 4.5.2 MDAC 2.5.13 DataSource is setup as OLEDB NT4.0 sp5 SQL7.0 Located on same network. Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.com ~~ 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
