| T O P I C R E V I E W |
| nickpixel |
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?< |
| 7 L A T E S T R E P L I E S (Newest First) |
| nickpixel |
Posted - 17 January 2001 : 11:24:55
thank you much
< |
| gor |
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< |
| Doug G |
Posted - 17 January 2001 : 11:16:05
I thought the forums here were on SQL server?
======
Doug G
======< |
| nickpixel |
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.
< |
| gor |
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< |
| redbrad0 |
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 |
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< |
