| Author |
 Topic  |
|
|
VodkaFish
Average Member
USA
654 Posts |
 Posted - 22 March 2001 : 14:44:12
|
i back up my snitz everyday. it's growing slightly each day. i know access has limitations. but i'm not sure what they are. i also know it has supposed speed issues, but i'm more concerned about size. anyone who can let me know this stuff?
v ø d k â f ï § h |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 22 March 2001 : 15:29:37
|
I believe an Access DB can grow to 1 or 2 GB
======
Doug G
====== |
 |
|
|
RaiderUK
Average Member
United Kingdom
577 Posts |
Posted - 24 March 2001 : 19:04:39
|
Well mine is very big, but i think access can get to 5gb.
--------------------
Please let me have
more pills doctor
-------------------- |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 25 March 2001 : 02:03:47
|
The size limit of an Access database is 1 GB
With MSDE 1.0 or the SQL Server 2000 Desktop Engine you can go up to 2 GB
MS Sql Server 7.0/2000 can store up to 1,048,516 TB of data
Technically an Access database has no size limit, because you can link to tables in other databases from within an Access database.
Also remember that when you delete records from an Access database, the size doesn't shrink. You need to Compact the database for that to happen.
The largest Access database I've ever used was about 500 MB, and that is huge (wasn't for a Snitz forum though). It should never reach that size used in combination with the forums. Your forum would much sooner become way too slow than that you reach the size limit of 1 GB.
Pierre |
|
|
|
RaiderUK
Average Member
United Kingdom
577 Posts |
Posted - 25 March 2001 : 19:27:20
|
ok sorry for the false info, i'm sure someone told me it could grow to 5gb, but that goes to show dont belive everything people tell you.
--------------------
Please let me have
more pills doctor
-------------------- |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 26 March 2001 : 01:33:22
|
quote:
ok sorry for the false info, i'm sure someone told me it could grow to 5gb, but that goes to show dont belive everything people tell you.
But you believe what I tell you without a second thought ? 
Pierre |
|
|
|
RaiderUK
Average Member
United Kingdom
577 Posts |
Posted - 26 March 2001 : 11:17:49
|
good question.
|
|
|
|
VodkaFish
Average Member
USA
654 Posts |
Posted - 26 March 2001 : 15:14:43
|
well, my snitz isn't close to that, but i assume it will get big. is the only way to prevent a growing snitz to delete topics? (and then compact)?
v ø d k â f ï § h |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 26 March 2001 : 15:35:57
|
Archiving...like is in the new Alphas...isn't a real option, since that stores the info in the same database...but it would speed things up a bit...since the tables that get hit for i.e. search are smaller.
But other than that....nothing else you can do then delete from time to time...or upgrade to MS SQL or MySql.
Pierre |
|
|
| |
Topic |
|
Topic Locked
