Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - Create new forum to decrease database ?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Create new forum to decrease database ?

 Post Reply Post Reply
Author
Lynford View Drop Down
Groupie
Groupie


Joined: 14 December 2004
Status: Offline
Points: 171
Post Options Post Options   Thanks (0) Thanks(0)   Quote Lynford Quote  Post ReplyReply Direct Link To This Post Topic: Create new forum to decrease database ?
    Posted: 24 May 2005 at 12:49pm
Hi there,
You may remember that I posted a while ago. My MB was the Access one with a 220mb database !!!!LOL
 
After all of your help, we managed to chop it down to a reasonable size (deleting PM's / post / unused members etc) As soon as we get time, we will be going over to MS SQL to solve (hopefully) all of our problems.
 
In the meantime, we have 1 massive thread on the board which we really don't want to delete, but I guess it is still causing us problems size wise.
 
If I create a new forum on the MB and move this thread into there, will it create a new Database file for that forum, which won't be accessed when people are using the 'normal' MB, therefore making the 'normal' MB Database file much smaller ?
 
Thanks, as ever, for all of your help Big smile
 
Lynford.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 24 May 2005 at 12:53pm
No it wouldn't, thats the problem with Access is that it is a flat file database system
Back to Top
Lynford View Drop Down
Groupie
Groupie


Joined: 14 December 2004
Status: Offline
Points: 171
Post Options Post Options   Thanks (0) Thanks(0)   Quote Lynford Quote  Post ReplyReply Direct Link To This Post Posted: 24 May 2005 at 12:56pm
Originally posted by -boRg- -boRg- wrote:

No it wouldn't, thats the problem with Access is that it is a flat file database system
 
Ok, thanks anyway Big smile
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.