Web Wiz Support and Community Forums : Access | MSSQL | MySQL https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 06:32:10 +0000 Sat, 22 Oct 2005 11:28:15 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=11806 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Access | MSSQL | MySQL : Hy guys, Good News for everybody...]]> https://forums.webwiz.net/access-mssql-mysql_topic11806_post92557.html#92557 Author: webservo
Subject: 11806
Posted: 22 October 2005 at 11:28am

Hy guys,

Good News for everybody that uses WWF. I'm also a wwf enthusiast. As I had need to migrate to another hosting service that hadn't MS SQL-Server, I decided to face the task of converting it to MySQL . I was using a 7.9 MSSQL version. See it running at my gospel portal in ::FCG:: Fórum Central Gospel - Really, that wasn't a fast and easy conversion, but it is possible !!! Believe enough !!! If you are a wwf enthusiast like me and "need" to be free from MSSQL-Server that's the way!
 
I've just posted to Borg in order to help in MySQL converting support to WWF version 8. I'm waiting for his answer so that the new WWF may be released at least with MySQL support instructions.
 
]]> Sat, 22 Oct 2005 11:28:15 +0000 https://forums.webwiz.net/access-mssql-mysql_topic11806_post92557.html#92557 <![CDATA[Access | MSSQL | MySQL : -boRg- wrote:If they haven&#039;t...]]> https://forums.webwiz.net/access-mssql-mysql_topic11806_post91632.html#91632 Author: Lynford
Subject: 11806
Posted: 03 October 2005 at 9:30pm

Originally posted by -boRg- -boRg- wrote:

If they haven't noticed yet then OK, but be prepared to wake up one morning to find your site not there with a suspension email telling you to upgrade to MS SQL Server at a cost of £300 per year + the VAT!!

They have done this 3 times now to sites I have placed on their servers.

Not entirly sure how they stand now with the Win 2003 servers as it's the abuse department (who you can not talk to) that deals with this type of thing and the technical support guys don't have a clue on these matters.
 
I can vouch for that. They took my Forums off without warning. Then they told me to sort the problem out, but took days to give me FTP access back so I could do it !!!
]]> Mon, 03 Oct 2005 21:30:42 +0000 https://forums.webwiz.net/access-mssql-mysql_topic11806_post91632.html#91632 <![CDATA[Access | MSSQL | MySQL : As been stated, Access performance...]]> https://forums.webwiz.net/access-mssql-mysql_topic11806_post65816.html#65816 Author: xeerex
Subject: 11806
Posted: 20 September 2004 at 10:38am

As been stated, Access performance and dependability depends on thehost and how they will work with you on application pooling, etc.Access's main problem is in concurrent connections. If in doubt, startoff with MSSQL.

For example, I have a 14.5MB Access database powering my largest forum.2 days ago it was running a sustained 80-120 active users and rarelydips below 20. Here are the stats as of today:

=======
We have 11507 Forum Members
Avg New Members per day: 50.36 (excluding today)
New Members today (so far): 26 | Yesterday: 40
# of Members Visiting Site Today: 415 (excluding new members)
Launch Date of Site: February 4th, 2004 (228 days of operation)
We have 5259 Posts in 883 Topics in 21 Forum(s)
Avg Posts Per Day: 23.07


This page was generated in 0.6094 seconds.
========

Now, I usually close the forum once every 2 weeks for an hour andcompact/repair it. It took about a bit of working with the host to getit stable but our downtime is generally very little. However, alwaysremember this:

Rule #1: You are only as good as your last SUCCESSFUL backup, which means you can recover from a crash.

One of the nice things about using Access is that I can download thedatabase file and manipulate it very easily or zip it up and keepbackups very easily. Yes, you can backup MSSQL databases as well, butAccess is easy for general users since most people have MS Office andWinZip (or something similar).

I use a combination of an app from www.secondcopy.com and WebDrive tomake daily and weekly backups of my databases from my host to myhome/office test server. Its a cheap and easy solution. That way, I'monly out 1-2 days at the most. You can also do this with some ftpclients such as CuteFTP Pro but they are kinda limited in the backupfunctionality.

Again, MSSQL is by far superior in performance and scalability andshould be the choice; however, Access can work with a little TLC.
]]> Mon, 20 Sep 2004 10:38:24 +0000 https://forums.webwiz.net/access-mssql-mysql_topic11806_post65816.html#65816 <![CDATA[Access | MSSQL | MySQL : If they haven&#039;t noticed...]]> https://forums.webwiz.net/access-mssql-mysql_topic11806_post65781.html#65781 Author: WebWiz-Bruce
Subject: 11806
Posted: 20 September 2004 at 8:19am

If they haven't noticed yet then OK, but be prepared to wake up onemorning to find your site not there with a suspension email telling youto upgrade to MS SQL Server at a cost of £300 per year + the VAT!!

They have done this 3 times now to sites I have placed on their servers.

Not entirly sure how they stand now with the Win 2003 servers as it'sthe abuse department (who you can not talk to) that deals with thistype of thing and the technical support guys don't have a clue on thesematters.

I try not to use Fasthosts anymore apart from for the odd small site ona reseller account I have as the service is lousy and they try and getextra money out of you for everything.


Edited by -boRg-]]> Mon, 20 Sep 2004 08:19:21 +0000 https://forums.webwiz.net/access-mssql-mysql_topic11806_post65781.html#65781 <![CDATA[Access | MSSQL | MySQL : My database is currently 15mb...]]> https://forums.webwiz.net/access-mssql-mysql_topic11806_post65777.html#65777 Author: ianewoods
Subject: 11806
Posted: 20 September 2004 at 7:05am

My database is currently 15mb and is on a fasthosts server!

Regards
Ian Woods
www.magicmushroomforum.co.uk

]]> Mon, 20 Sep 2004 07:05:40 +0000 https://forums.webwiz.net/access-mssql-mysql_topic11806_post65777.html#65777 <![CDATA[Access | MSSQL | MySQL : The speed that access runs at...]]> https://forums.webwiz.net/access-mssql-mysql_topic11806_post65763.html#65763 Author: WebWiz-Bruce
Subject: 11806
Posted: 20 September 2004 at 4:21am

The speed that access runs at depends allot on the server you site is on.

On fast servers with allot of memory and not allot of sites you can get away with over 100mb Access database.

But as most hosts tend to pack to many sites onto a server, allot ofweb hosts will not allow databases over 10Mb in size, and there are afew I know (Fasthosts is one) who will suspend your account withoutwarning if you have an access database over 10mb.

So it's worth checking with your hosts first.
]]> Mon, 20 Sep 2004 04:21:46 +0000 https://forums.webwiz.net/access-mssql-mysql_topic11806_post65763.html#65763 <![CDATA[Access | MSSQL | MySQL : I currently have the Access version...]]> https://forums.webwiz.net/access-mssql-mysql_topic11806_post65750.html#65750 Author: JohnKn
Subject: 11806
Posted: 19 September 2004 at 4:50pm

I currently have the Access version running. The db is over 50 meg,2,000+ registered users, average 170 new posts / day and most forumpages still load in well under 1 second. Searchs take longer of course,anywhere from 1-10 seconds depending on the search.

If you think you'll have a high traffic site I'd go with MS SQL, but if not the Access version works fine.
]]> Sun, 19 Sep 2004 16:50:46 +0000 https://forums.webwiz.net/access-mssql-mysql_topic11806_post65750.html#65750 <![CDATA[Access | MSSQL | MySQL : If you resident in denmark I can...]]> https://forums.webwiz.net/access-mssql-mysql_topic11806_post65714.html#65714 Author: likedon
Subject: 11806
Posted: 18 September 2004 at 2:51pm

If you resident in denmark I can give it to you for 20 dkr./md if you are hostet with me(from 59 dkr/md)

For more info go to my website
]]> Sat, 18 Sep 2004 14:51:49 +0000 https://forums.webwiz.net/access-mssql-mysql_topic11806_post65714.html#65714 <![CDATA[Access | MSSQL | MySQL : also access is known to currupt...]]> https://forums.webwiz.net/access-mssql-mysql_topic11806_post65712.html#65712 Author: dj air
Subject: 11806
Posted: 18 September 2004 at 2:34pm

also access is known to currupt easily.

you can get MSSQL hosting for as little as $6.99 a month that is cheep and the hosting is very good.
]]> Sat, 18 Sep 2004 14:34:46 +0000 https://forums.webwiz.net/access-mssql-mysql_topic11806_post65712.html#65712 <![CDATA[Access | MSSQL | MySQL : Problems with Access are that...]]> https://forums.webwiz.net/access-mssql-mysql_topic11806_post65707.html#65707 Author: theSCIENTIST
Subject: 11806
Posted: 18 September 2004 at 12:53pm

Problems with Access are that it is slower, but not immediatly aparent, only slows down when you have a few hundred users and a few MB's of MDB filesize.

As for MySQL, there's no plans to add a MySQL backend version of WWF because, see this post by me sometime ago: www.webwiz.net/wwf_forum/forum_posts.asp?TID=7730

I have decided that coding a new forum system from scratch would be a waste of time, there's already many good forums out there, and I would be only wasting my time.

]]> Sat, 18 Sep 2004 12:53:01 +0000 https://forums.webwiz.net/access-mssql-mysql_topic11806_post65707.html#65707