Re: Maintaining database connections :: not working

2007-10-03 Thread Simon Harper
Hi again, Thanks for taking the time to point me in the right direction with this one. I've done a little more investigation and I've discovered that this the change in behaviour is not simply due to the move from CF7 to CF8. I am happy to confirm that I have now seen DB connections pooled

Re: Maintaining database connections :: not working

2007-10-03 Thread Tom Chiverton
On Wednesday 03 Oct 2007, [EMAIL PROTECTED] wrote: 1. Should one put .cfm files under the WEB-INF directory? Nope. We have a separate web root, set that as DocumentRoot in Apache and all is well. -- Tom Chiverton Helping to enthusiastically orchestrate error-free features on:

RE: Maintaining database connections :: not working

2007-10-02 Thread Simon Harper
Having just moved one of our sites from CF7 to CF8 I've noticed that the connection pooling (Maintain Connections) setting is not working This is having a horrible effect on performance of the site Dave Watts wrote: If you check the neo-datasource.xml file for your datasource, do you see

Re: Maintaining database connections :: not working

2007-10-02 Thread Simon Harper
How do you know it's not working ? Poor performance could be a vast number of things. Hi Tom, You're right to suspect that I don't have any direct evidence for this ;-) I'm basing my suspicion on the fact that I see the following in the database logs: Oct 2 08:55:56 db_server xinetd[2232]:

Re: Maintaining database connections :: not working

2007-10-02 Thread Tom Chiverton
On Tuesday 02 Oct 2007, [EMAIL PROTECTED] wrote: You're right to suspect that I don't have any direct evidence for this ;-) Well, I'd certainly fire up the server monitor or DB layer debugging then. Maybe your CF8 site is just busier :-) -- Tom Chiverton Helping to continuously enable B2B

Re: Maintaining database connections :: not working

2007-10-02 Thread Simon Harper
Thanks Tom - will do. -- [EMAIL PROTECTED] Applications Development Manager Warwick Business School Tom Chiverton [EMAIL PROTECTED] 02/10/2007 14:13 On Tuesday 02 Oct 2007, [EMAIL PROTECTED] wrote: You're right to suspect that I don't have any direct evidence for this ;-) Well, I'd certainly

Re: Maintaining database connections :: not working

2007-10-01 Thread Tom Chiverton
On Monday 01 Oct 2007, [EMAIL PROTECTED] wrote: Having just moved one of our sites from CF7 to CF8 I've noticed that the connection pooling (Maintain Connections) setting is not working (I've unticked and ticked again to check!). How do you know it's not working ? Poor performance could be a

RE: Maintaining database connections :: not working

2007-10-01 Thread Dave Watts
Having just moved one of our sites from CF7 to CF8 I've noticed that the connection pooling (Maintain Connections) setting is not working (I've unticked and ticked again to check!). The sites left on the CF7 installation are still working with the same driver as I would expect. This is