Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Access Database Size
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Access Database Size

 Post Reply Post Reply Page  <12
Author
xenophine View Drop Down
Groupie
Groupie
Avatar

Joined: 28 April 2005
Location: Turkey
Status: Offline
Points: 51
Post Options Post Options   Thanks (0) Thanks(0)   Quote xenophine Quote  Post ReplyReply Direct Link To This Post Posted: 22 December 2006 at 12:13am
i have about 6000 users, 40.000 messages and max online user at one time is nearly 10.. my access db size is 100 mb and i'm using wwf v7.9.. i didnt have any error or slowing yet.

(1)but sometimes while clicking to a link, connection dont responses about thirty seconds and then loads the page fastly. i think it is about my host. isnt it? or this is a database slowment?

(2)am i have to change my server to SQL? or can i continue it until nearly 500 mb access database with these online statistic?

what is your opinions about these statistics and growing? sorry for my bad english:) and regards..
Back to Top
xenophine View Drop Down
Groupie
Groupie
Avatar

Joined: 28 April 2005
Location: Turkey
Status: Offline
Points: 51
Post Options Post Options   Thanks (0) Thanks(0)   Quote xenophine Quote  Post ReplyReply Direct Link To This Post Posted: 26 December 2006 at 4:43pm
please help me, i'm in a trouble..

don't say "change your database to sql". i know i have to..

but i want to learn, my access database can go until what growth?
i'm having slowments and time outs because of the 100 mb access db with nearly 10-20 connections at the same time.
is it true, are these statistics are big for a web wiz forums 7.9 with access database?
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: 27 December 2006 at 10:39am
For a forum that size Access database is way to much because of the amount of read and writes performance on the database to get all the data, however, if you really can't use SQL Server or mySQL you should at very least upgrade to version 8 not only for security, but also because it has been highly optimised cutting many pages from over 30 database hits down to no more than 2 or 3 for most pages so would be much better and faster and many less database hits so less chance of database corruption.
Back to Top
xenophine View Drop Down
Groupie
Groupie
Avatar

Joined: 28 April 2005
Location: Turkey
Status: Offline
Points: 51
Post Options Post Options   Thanks (0) Thanks(0)   Quote xenophine Quote  Post ReplyReply Direct Link To This Post Posted: 27 December 2006 at 1:30pm
thanks for your answer boRg. i can use mysql server on my host.. but it's too hard to change db type, cuz i'm beginner at databases :) i will try, i hope i can.
Back to Top
 Post Reply Post Reply Page  <12

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.