Snitz Forums 2000 - Snitz Stored Procedures

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Community Discussions (All other subjects)

Snitz Stored Procedures

New Topic

Topic Locked

Printer Friendly

Author

Topic

redbrad0
Advanced Member

USA
3725 Posts

Posted - 28 August 2003 : 17:53:30

Has anyone attempted, or a group of us like to attempt to alter the snitz forum to use stored procedures? Even if not all the code uses stored procedures I bet it could help out. There could be another option in the config.asp file link this...


'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
strDBType = "sqlserver_sp" ' USE STORED PROCEDURES
'strDBType = "sqlserver" ' STANDARD SQL DATABASE
'strDBType = "access"
'strDBType = "mysql"

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets

snaayk
Senior Member

USA
1061 Posts

Posted - 28 August 2003 : 23:41:23

Actually, you could, by default, use sprocs with MSSQL or Access. And only have to use straight sql for mysql.

Perhaps you could use certain include files depending on the strDBType

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 29 August 2003 : 03:32:02

If you converted to SP's I suspect many would end up needing to be dynamic in which case any performance improvements through the use of stored procedures is questionablee e.g http://www.4guysfromrolla.com/webtech/sqlguru/q120899-2.shtml (though they beleive it's still worth using them in the long run) It would probably make modding the forum a pain for folks as well who don't have access to MS SQL etc so all their mods would be written with inline SQL instead initially.

Kiwihosting.Net - The Forum Hosting Specialists

redbrad0
Advanced Member

USA
3725 Posts

Posted - 29 August 2003 : 17:23:04

Yea your right, im just thinking about one of my customers who site is very active and take this forum for example. If some main querys were stored procedures could it help? How much would it help? Would it be worth it?

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 29 August 2003 : 20:34:10

It should help, but it's probably one of those things where you really need to go and do it and then compare/see what savings if any that you achieved. I'm sure theres a few queries that would be good candidates for SP's just a case of taking the time to find them and then test it really.

Kiwihosting.Net - The Forum Hosting Specialists

VodkaFish
Average Member

USA
654 Posts

Posted - 31 August 2003 : 20:03:01

I took many of my pages of my main site and coverted the sql statements to SPs and it helped greatly. Let me add that they are all dynamic, usually using multiple variables. Still helped lots. But - there was one odd occurance that it didn't, and actually seemed to slow it down. As Gremlin said, best thing to do is test them out.

I have a forum that generally had 30-40 people on it during my offseason. I think at least double that will be active during my normal season (and most are posters, many posts a day). I'd like to see how SPs would help.

v ø d k â f ï § h

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.3 seconds.