| Author |
 Topic  |
|
Pelle
Starting Member
24 Posts |
 Posted - 01 January 2003 : 19:03:35
|
I have some questions.
Wouldn't it be good to update the SQL to be an Stored Procdure in the SQL server instead of regular SQL like 3.4?
Also I have a suggestion; Update the DB to have an USerID for the top Forum, giving the option for the ISP to have more than one forum on the same server.
Is there any mod that gives the option to subsribe a topic and recieve email when replied?
This is my first message but many more will come. I am ASP/SQL programmer running an own webservice with several servers on a leased line ;-)< |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 01 January 2003 : 19:23:26
|
quote:
Wouldn't it be good to update the SQL to be an Stored Procdure in the SQL server instead of regular SQL like 3.4
Yes it would however the forum is designed to be used by multiple Database backends (Access, MySQL, MSSQL) not all of which support Stored Procedures, right now the code is as generic as it can be to maintain compatability with all those database engines. Adding stored procedures would add additional work when anything needs to be changed in the code. Becuase Snitz is GPL though you are of course free to add them yourself.
quote:
Update the DB to have an USerID for the top Forum, giving the option for the ISP to have more than one forum on the same server
I'm not sure what you mean here, you can have as many forums as you like on the same server each would have their own unique database names. I have around 12 running on my test server here at home right now.
quote:
Is there any mod that gives the option to subsribe a topic and recieve email when replied?
It's built into the forums already, simply enable subscriptions from your admin settings.
< |
Kiwihosting.Net - The Forum Hosting Specialists
|
Edited by - Gremlin on 01 January 2003 19:24:10 |
 |
|
|
Pelle
Starting Member
24 Posts |
Posted - 02 January 2003 : 05:27:50
|
quote:
the forum is designed to be used by multiple Database backends (Access, MySQL, MSSQL) not all of which support Stored Procedures
This can be solved by If strDBType = "sqlserver" then strSql="EXEC SPlogin @Name....." else strSql="select ......" End If. Or am I wrong?
quote:
you can have as many forums as you like on the same server each would have their own unique database names.
But they can not have unique designs and URLs.
Like
UserForum 1 = "The soundcard guide" with blue colours running on "www.soundcards.not"
UserForum 2 = "all you wanna know about cooking" with gray colours running on "www.food.not"
If I need this I have to set up twice tables and have different strTablePrefix. It think it would be easier to have just an ID for the userForum...
quote:
lequote:
Is there any mod that gives the option to subsribe a topic and recieve email when replied?
It's built into the forums already, simply enable subscriptions from your admin settings
Oooups! :-) Where do I have that option in the admin?
< |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 02 January 2003 : 06:55:41
|
quote:
Originally posted by Pelle
Like
UserForum 1 = "The soundcard guide" with blue colours running on "www.soundcards.not"
UserForum 2 = "all you wanna know about cooking" with gray colours running on "www.food.not"
If I need this I have to set up twice tables and have different strTablePrefix. It think it would be easier to have just an ID for the userForum...
Take a look at the Category grouping feature. I think thats about what it does. (though I have never used it myself)
quote:
Oooups! :-) Where do I have that option in the admin?
Look in the feature configuration "Highest level of Subscription"< |
 Nathan Bales
CoreBoard | Active Users Download |
Edited by - Nathan on 02 January 2003 06:55:58 |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 02 January 2003 : 07:34:58
|
That was kinda my whole point, adding all those If strDBType = in to the code is a lot of 'exception' coding. Right now theres only a very few instances of where specific SQL is required to suit a particular Database type.
Only if your wanting to share the same MEMBERS table would you do it that way, normally you'd just have multiple databases.< |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
Pelle
Starting Member
24 Posts |
Posted - 02 January 2003 : 08:12:24
|
quote:
Originally posted by Nathan
Take a look at the Category grouping feature. I think thats about what it does. (though I have never used it myself)
No, this is "only" a way of grouping groups :-))
quote:
Originally posted by Gremlin
Right now theres only a very few instances of where specific SQL is required to suit a particular Database type.
Ok, I get your point, but I really do think that SQL server will increase in using... Performance access/SQL is sometimes huge on well visited forum...
quote:
Originally posted by Gremlin
Only if your wanting to share the same MEMBERS table would you do it that way, normally you'd just have multiple databases.
It is much easier to set up new UserForums if I only add a new post in the "UserForum" table instead of creating new tables all the time. And I also think that having more tables will increasae the DB much more than having more posts in the tables< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 January 2003 : 09:14:56
|
There are several Snitz users who host several forums, some of them even with Access databases (I think I remember someone who wanted to host 12 forums with a single Access DB).
I've helped several people who used two or three forums with SQL Server DBs. The current way to setup several forums works perfectly OK, both for completely independent forums or, for example, forums that share the same user DBs, or the badwords and names filters. IMO, the SQL is much cleaner than having a user ID being dragged in every SQL statement to access forum contents.
Also my belief is that from a software engineering point of view, this is also the best option. The most common situation is for a single forum situation, and the code is optimized for that, as it should. Yet, it allows you with almost equal ease, to setup as many forums you like in a single database. What do you want more?< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
pweighill
Junior Member
United Kingdom
453 Posts |
Posted - 02 January 2003 : 10:04:21
|
| Keeping them all separate will also mean that searching will be quicker.< |
|
|
|
Pelle
Starting Member
24 Posts |
Posted - 02 January 2003 : 10:21:32
|
Rurib.
Oki, I guess I'm not the average user so i do drop those ideas...
But I dont agree in that it is cleaner to have different tables than just a userID in the SQL.
My thoughts is baseds on that we host about 10-15 different forums on our servers, and it would be great for us to implement al this to the same SB AND tables for quick setup on new forums. But never mind. It isn't THAT hard to do the way it is now. But isn't that hard way to include userID in the SQL either.< |
|
|
|
Pelle
Starting Member
24 Posts |
Posted - 02 January 2003 : 10:26:24
|
A reason till why I wanna be member of the DEV team is that I have to make a own forum, and instead of spending 2 weeks on an own soloution, I can speed up this project instead....
Thats a BIG reason, for everyone :-)< |
|
|
|
Pelle
Starting Member
24 Posts |
Posted - 02 January 2003 : 10:28:21
|
quote:
Originally posted by pweighill
Keeping them all separate will also mean that searching will be quicker.
I guess i'm to used to SP and SQL server instead of access with seams to be the most used way for SF2000.
If you have the userID as a key it is no slower in searching on SQL server.
But as I said before, i drop this thought cause the big number of accessusers...< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 January 2003 : 10:35:35
|
Pelle,
Pweighill did raise an important issue. Searching timeouts are an important problem with bigger SQL Server DBs, and if you do put all the stuff from several forums in a single DB, and some of those forums have "some movement", with some users posting regularly, after some time it is likely that you wouldn't be able to use the search feature in its current form.
I still think my previous points are relevant, but there is no point in insisting on them. I do respect your disagreement though  .< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Pelle
Starting Member
24 Posts |
Posted - 02 January 2003 : 11:15:21
|
 < |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 02 January 2003 : 21:19:47
|
The use of SP's (most of which will have to be dynamic SP's anyway) doesn't actually make a huge improvement to the forums, the current version had a lot of tweaking to the code done which has made it pretty fast anyway, I have an earlier version of Snitz I rewrote to use SP's, the current version is now *faster* than my SP version.
quote:
A reason till why I wanna be member of the DEV team is that I have to make a own forum, and instead of spending 2 weeks on an own soloution, I can speed up this project instead....
Thats a BIG reason, for everyone :-)
You don't need to be on the DEV team around here to assist, you can release your modifications to the other users via the MOD forums and also request changes you might like also. We share everything around here :)< |
Kiwihosting.Net - The Forum Hosting Specialists
|
Edited by - Gremlin on 02 January 2003 21:22:28 |
|
|
|
Pelle
Starting Member
24 Posts |
Posted - 03 January 2003 : 04:05:15
|
Thats not true?
I can't find the alpha on B4 so I can see what needs to code..
Please give me a job ;-)< |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 03 January 2003 : 04:45:36
|
As far as I know becoming an official "DEV" is by inviation only but don't let that stop you from taking the current source code and modifying it to suit yourself, if along the way you think others could benefit from the changes (MODs) you make then feel free to post them in the appropriate forum here.
Information on V4 can be found in this forum http://forum.snitz.com/forum/forum.asp?FORUM_ID=105< |
Kiwihosting.Net - The Forum Hosting Specialists
|
Edited by - Gremlin on 03 January 2003 04:47:31 |
|
|
|
Topic |
|
Forum Locked
