database size/ forum moving slowly

Bunce wrote: Is there a specific reason that this small increase in size is a problem?

well.. what happened in my case is my forum was so slow that my members couldn't post.. we were having to copy our posts before we submitted them because in most cases, the forum would time out and we would lose our post.. so we would at least have it copied to just paste back on. 

all the advice I found said that my database was getting to large.. so when I compacted it, from 9 down to 8.6 that didn't do much good.. then a week later it was up to 11+   and if it was slow at 9.. and growing at that rate.. I figured we were in for trouble.

ask023 wrote: Could you tell me please, is it serious that 10Mb - Access DB may be slow down my forum?? If I'm going to have 100-200 active users and my DB will be 10-15Mb, am I MUST to upgrade to MS SQL?? Thank you very much for reply! If yes (I have to move to SQL ASAP), could you tell me please, were slowing downs noticed in MS SQL DB? What version (7/2000) should I use under Win2003?

all I can tell you is in my case.. the larger database size seemed to make a huge difference.  If you go to  my forum at www.chubbuddies.com (it's being moved now so might be down)  but there are so many posts on there from members complaining about not being able to get in.. or losing their posts.. or the forum running too slow.. etc.. so it was in my best interest to move to SQL server now because I anticipate growth to continue.

I researched SQL servers, and wanted one that was famiular with WWF because I may need a lot of help.. and I found that BoRg uses GearHost for this forum.. and I took a look at their prices and they are VERY competitive.. a lot cheaper then most other servers I found that offer the exact same thing or less!

Please check them out if you are going to change.. I have been in contact with Ryan (the CEO/founder) at GearHost.. and he is a wonderful man to work with.. I found him to be extreamly helpful and very kind.  I hate to move from WWH because I wanted to give BoRg at least some type of business since the forum is free.. but as it turns out I need to move..  

So anyone needing SQL server, take a look at GearHost.. and tell them that BoRg sent you because I think he may benefit from it!? 

Well.. I guess time will tell?!   

While searching WWF for answers on this, I found many posts that say Access has a feature to convert your database, but I didn't want to mess with it because I have ZERO experience with databases.  I talked with GearHost and for $10 more, he said he would convert it for me. 

I paid for the platnium account which comes with a MsSQL and I think 4 MySQL (but from reading here, the forum isn't compatable with MySQL without a lot of work)  Or you can get their gold account and add a MsSQL for only $6.00 more a month. 

I transferred my database to them yesterday.. then he downloaded another copy of it himself (as a back up for me) and when I go into my control area I see the MsSQL database there. 

Unfortunatly, BoRg is gone till Monday, so I can't have him redirect my domain name.  GearHost was supposed to do something temp. to redirect my domain to my GearHost account.. but I haven't heard if it's done yet or not.

but it didn't seem to be a problem for them to transfer everything to MsSQL.  I wanted something that would give us loads of room to grow because in 2 months.. this is my second upgrade already!  Guess we are a popular board!!  And we rate very high in the search engines already.. it's WAY COOL!!

hi guys?

i've used this forum on our office intranet and still using access for database, the question is : how to convert my access to MSSQL?, our office server has MSSQL installed.

thanks before

BTW, I think WWH is a reseller of GearHost...