| Author |
 Topic  |
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
 Posted - 09 August 2007 : 07:09:08
|
I'm looking at the database structure due to heavy load problems (60 Mb big), and found that the FORUM_ID key in FORUM_FORUM wasn’t exclusive, that will say doublets are aloud in FORUM_ID. Why?
If someone tries to write a post with the same subject that’s already exist, should this be rejected, with reference to the existing post?
Why wasn’t the database in Snitz-Forums planned as a relation database. I’m not sure whether or not I’ve asked before, but if I did, it was so long ago so neither me or any other members probably remember the answer or reason behind the database structure of today.
Thanks
Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 09 August 2007 : 08:13:34
|
FORUM_ID is exclusive, it is the primary key, you can't have a primary key that is not exclusive.
quote:
If someone tries to write a post with the same subject that’s already exist, should this be rejected,
No, why should it be rejected ??
quote:
Why wasn’t the database in Snitz-Forums planned as a relation database.
because it is generic and done in code.
if you are having heavy load problems it is not because of the size, size does not equate to load, number of simultaneous connections equates to load, if you are having issues then switch to MSSQL or MySQL |
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 09 August 2007 : 08:19:32
|
| you must have done something to your db if FORUM_ID is not exclusive indexed, since the one in the download is, as are the SQL db's. |
|
|
|
tomasalsbro
Average Member
Sweden
818 Posts |
Posted - 10 August 2007 : 08:09:53
|
quote:
Originally posted by HuwR
No, why should it be rejected ??
Because the subject already exist, and if a member need to extend the question, answer or subject - why should this not be done in the same subject?
quote:
because it is generic and done in code.
OK
quote:
if you are having heavy load problems it is not because of the size, size does not equate to load, number of simultaneous connections equates to load, if you are having issues then switch to MSSQL or MySQL
OK, are their any tools in order to switch to MySQL or MSSQL?
Thanks / Tomas |
!-Keep distance in traffic-!
www.whiplashinfo.se |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 August 2007 : 09:22:52
|
quote:
Because the subject already exist, and if a member need to extend the question, answer or subject - why should this not be done in the same subject?
Well, if you can stop people asking the same question over and over again you are better than we are  |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 10 August 2007 : 09:24:42
|
I was getting ready to add that there are too many ways to ask the same question without using the same title... a short perusal of the forums here is more than adequate proof of that. 
Edit: I should add that it works the other way too.. I've seen people use the same title for different questions.  |
Edited by - AnonJr on 10 August 2007 09:25:28 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 August 2007 : 09:26:56
|
| yep, the most annoying being 'help' |
|
|
| |
Topic |
|
Topic Locked
