> The Sybase DB hosts a PeopleSoft database and it has > dedicated 3 CPU's to run. The ColdFusion has only one > dedicated CPU. This setup was left by my predecessor. > The puprose of coldfusion here is to server finacial > management reports which are taken out of the PeopleSoft's > DB and presented on the Intranet. There the problems start, > every query is about 15 times slower if executed via > coldfusion, Stored Procedures bring a performance gain > but there is no time/manpower to rewrite all the reports > to use SP. The queries are very well optimized so there > must be a slow down on the ColdFusion side. While running > queries the CPU load of the coldfusion CPU is 100 %.
Are you running anything else through the Sybase client installed on the same machine? If so, is that also slower? If not, have you looked on the Sybase site to see if there are any known issues with the version of the Sybase client you have installed? > My thought was to remove the ColdFusion from this server > and set it up on a Windows box (1.5 Ghz or more and 1 or > 2 gigs of RAM). Does anybody have any recomendations or > experienced same problems? Or is my approach totally > wrong and it's only a configuration thing. Even if it's only a configuration thing, you might want to do that anyway, if you can afford to. You might also want to see if there's a new version of the Sybase client available, and see if that has anything to do with the problem. You might also want to consider upgrading to CF 5 or CFMX, since their interfaces to Sybase might work a little better (although you really shouldn't have to do this, I admit). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
