| Author |
 Topic  |
|
|
jonnyboy
Starting Member
1 Posts |
 Posted - 24 April 2008 : 19:22:33
|
Hi all
I'm having issues with my hosting company from whom I received the following :
We have been investigating the performance issues you reported with this site and found that unforutnately, your site was causing performance problems on the shared webserver on which it was hosted. We are confident that that your site has been contributing to this issue. More details as to the nature of the problem will be found below.
As a result of this problem we have acted to move your website to our probation servers, these servers provide a separate hosting environment that we maintain specifically to allow our customers to diagnose and resolve performance issues with their sites. This action on our part gives you the opportunity to alter the site as required so that we can then consider moving it back to the standard hosting environment without affecting the performance of the other hosted sites.
While your site is hosted on our probation servers you are likely to experience performance below the levels that we normally provide to our shared hosting customers.
The problem is:
The site is leaving database connections open on the server. I found 7 open on the server.
Scripts should only need to open a database for the split second(s) needed to access the information for that page/request. There should be no need to leave connections open once a page is loaded as this consumes resources.
Additionally, I note that at least one of your databases is around 35MB.
Access, whilst it can be used in this way, was never designed for web applications. Whenever one item is needed on the database the whole database has to be loaded into memory and processed on the web server.
When you start looking at Access databases of over 5-10MB in size, then you should really be considering upsizing it to a Ms or My SQL database, where only the items required need to be processed by the web server and not the whole database, each time.
I would be interested to know if anyone has had similar issues with open connections. Also, the database and number of connections (lucky to get 6 logged-in members, plus upto 10 guests - usually the search engines doing there stuff) doesn't seem excessive to me!
I'm running a ServerHacker version of Snitz (3.4.03)
www.reading-forum.co.uk
Is it time to upgrade the database, which is a frightening thought, as I know nothing about MySQL, or SQL
Any advice appreciated.
|
John |
Edited by - jonnyboy on 24 April 2008 19:24:30 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 April 2008 : 19:57:15
|
| The problem with running modded versions is precisely that one. We can vouch for our base versions but the mod creator's need to vouch for their own versions. I know ServerHacker has left the scene, but I have always written here that I the problem with the versions based on an individual's code is the lack of a community support for that code. There is a forum to support the SHN, try visiting it and ask for help with them. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 25 April 2008 : 01:53:24
|
quote:
I found 7 open on the server
nothing really unusual about that, it entirely depends on what is going on, there is no way to tell for certain that these 7 were not in fact active connections.
quote:
There should be no need to leave connections open once a page is loaded as this consumes resources.
Shows a total misunderstanding of how ASP works, ALL database connections are closed automatically when a page has loaded.
quote:
When you start looking at Access databases of over 5-10MB in size
Total rubbish, I would also suggest finding a host that knows what they are talking about
As ruirib stated we do not offer support for fully modded versions of the forum code that are downloaded elsewher, you must use their support forums not ours if you require further support.
|
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 28 April 2008 : 11:30:05
|
Just to chip in my 2p -
7 active connections is negligible - in fact the way the locking works in Access db's there's no reason why that ought to be a concern at all. Indeed, even the act of looking at live db stats with any tool is likely to open maybe 3 connections in itself. As HuwR points out, though, IIS ISAPI filter for ASP will automagically close all db connections once they fall out of scope - at the end of EVERY page. COM+ may use connection pooling, but Snitz is not a COM+ application.
35Mb is not big for an access db - 2Gigs is, but 35Megs isn't. If you're worried, try downloading the db to your desktop, and performing a compact and repair on it, see if it shrinks down a bit. Snitz isn't wasteful though.
I would consider changing hosts, if their techies are telling you nonsense like this.
|
|
|
| |
Topic |
|
|
|
Topic Locked
