| Author |
 Topic  |
|
|
nickpixel
Starting Member
USA
11 Posts |
 Posted - 16 January 2001 : 18:43:56
|
i have a quick q to help me in my planning...
are these forums using a access or sql database?
and
how much room (in MB's) does the database currently take up?< |
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 16 January 2001 : 19:13:48
|
quote:
are these forums using a access or sql database?
You can use Access (database-file with tables included in the zip-file), the included file is an Access 97 database, but iy also works if you convert taht one to Access 2000.
You can also use Sql Server 6.5/7.0 or 2000 or Mysql (free !). You would just create an empty database and have the setup-script create the tables an defaultrecords for you.
quote:
how much room (in MB's) does the database currently take up?
That depends on how many messages/users you've got. The database starts with a couple of 100 Kb but the database here is > 50 MB by now.
Pierre< |
 |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 16 January 2001 : 19:34:18
|
gor,
the snitz database is 50 mb?
if im right snitz has 1982 members and 3895 topics, and 20404 replies. im not sure if this is right, cause i dont know what you have deleted but that seems good for 50 mb
Brad< |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 16 January 2001 : 21:17:29
|
Brad,
I did a Update Forumcount (that might explain why some of you had a troubles reaching the forums the last two or three minutes) and the current statistics are:
1328 Members
3379 Topics
32752 Posts *(= 30473 replies)
38 Forums
I don't know the exact size of the database, but we had some problems once because it was full (size was set to 50 MB) so that was why I said it was > 50 MB.
I would check it for you, but the tools I've got here don't show a database-size.
Pierre< |
|
|
|
nickpixel
Starting Member
USA
11 Posts |
Posted - 17 January 2001 : 09:06:46
|
sorry, i should have been more specific. i'm wondering specifically about these forums right here. i was wondering which database (sql or access) you cats are using and how large it is. i'm trying to figure out how big of a sql database i need. thanks in advance.
< |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 17 January 2001 : 11:16:05
|
I thought the forums here were on SQL server?
======
Doug G
======< |
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 17 January 2001 : 11:20:37
|
quote:
I thought the forums here were on SQL server?
They are, that is why I can't see how big the database is exactly (sorry, I see that I didn't say that before). We use Sql Server 7
Pierre< |
|
|
|
nickpixel
Starting Member
USA
11 Posts |
Posted - 17 January 2001 : 11:24:55
|
thank you much
< |
|
|
| |
Topic |
|
info on these forums
