Sounds like shared hosting... or do you have you own dedicated box? Disabling the database connections as steady state can be good in some circumstances... I have some things I run this way and others that I try always to maintain...
The OLE isn't the first choice... wondering why they recommended this? Load might seem to be the same, but the machine with bad/active neighbors could be doing it... or it might need rebooted.. or resources could be running lwo on the box (disk/RAM).. It's really hard to pin point anything other than that... I know lately having ran the exercise of looking for a hosting solution for a full CF project for a client, I wasn't impressed with hosting companies were offering and where their knowledge base was... Then again, if price is your argument, the adage of getting what you pay for, well it proves true. -paris Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] -----Original Message----- From: Ian Lurie <[EMAIL PROTECTED]> Date: Wed, 15 Jan 2003 13:26:21 -0800 Subject: OLE DB and Maintain Connections > Hi all, > > We've got a server that's suddenly become very cranky - running > slowly, > hanging, etc. 3-4 times per day. > > The hosting company told us that we should: > > 1. Uncheck 'maintain database connections' for all ODBC datasources. > > 2. Only use OLE DB for MSSQL datasources. > > Both of these seem counterintuitive to me - OLE DB is buggy as all > get > out, and I've always been told that 'maintain database connections' > is > a performance enhancer, not a drag. > > We're using CF 4.5.1 - traffic levels are about what they've always > been, and all session/app vars are appropriately locked. > > Any input? > > Ian > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 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
