Database connect issues

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
jonnyboy Members Profile Find Members Posts Newbie Joined: 02 January 2004 Status: Offline Points: 38	Post Options Post Reply Quote jonnyboy Report Post Thanks(0) Quote Reply Topic: Database connect issues Posted: 07 December 2004 at 9:28am
	Can anyone please help with this? My hotsing company suspended the site giveing this reason: "The domain has been inappropriately using system resources, causing a reduction in service for other account holders. Database scripting on your domain has been responsible for maintaining open connections beyond the server timeout configuration. This has caused a mounting resource issue that has reached a critical level. Our Engineers have observer more than 10 concurrent connections to htdocs\forum\admin\database\wwForum.mdb." Have you any idea what this means and how I can sort it? Thank you

dj air Members Profile Find Members Posts Senior Member Joined: 05 April 2002 Location: United Kingdom Status: Offline Points: 3627	Post Options Post Reply Quote dj air Report Post Thanks(0) Quote Reply Posted: 07 December 2004 at 10:08am
	if your host will only allow 10 connections, then i think its time to find a few host or upgrade to SQL, who is your host? what version of access also are you running. also may i advise you move the DB location outside of the website folders as your db is open to attacks.

jonnyboy Members Profile Find Members Posts Newbie Joined: 02 January 2004 Status: Offline Points: 38	Post Options Post Reply Quote jonnyboy Report Post Thanks(0) Quote Reply Posted: 07 December 2004 at 10:16am
	Im with http://www.streamlinenet.co.uk/pu.php with a power user package, unlimited user bandwidth. So basicaly this is because more than 10 people have been online at once?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 07 December 2004 at 10:30am
	The problem with Access is that it is very resource intensive, which is OK for small sites or small databases. The problem with using Access as the backed for a forum is that if the forum is popular it will use allot of server resources as it is a flat file database system, each time a user connects to your forum the entire database needs to be loaded into the web servers memory. In a shared hosting environment, if your database is over 10Mb in size and/or has allot of concurrent users, you should look into upgrading to MS SQL server version.
	Web Wiz Forums Hosting ASP.NET Web Hosting

jonnyboy Members Profile Find Members Posts Newbie Joined: 02 January 2004 Status: Offline Points: 38	Post Options Post Reply Quote jonnyboy Report Post Thanks(0) Quote Reply Posted: 07 December 2004 at 11:04am
	thank you

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum