Web Wiz Forums - Why doesn't WWF 8 use stored procedures?

Print Page | Close Window

Why doesn't WWF 8 use stored procedures?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20817
Printed Date: 11 April 2026 at 10:09am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Why doesn't WWF 8 use stored procedures?

Posted By: Ozbboy
Subject: Why doesn't WWF 8 use stored procedures?
Date Posted: 26 July 2006 at 1:25am

Quick question for Borg,

Is there any particular reason to not use stored procedures in WWF 8?

I remember there being stored procedures in a version of 7 that i had installed..

Is it to accomodate for mysql???

-------------
"http://www.ozbboy.com - www.ozbboy.com

Replies:

Posted By: WebWiz-Bruce
Date Posted: 26 July 2006 at 9:25am

Stored procedures where used in version 7, but they proved to be a real headache and made very little difference to performance.

By dropping stored procedures it meant that other techniques could be used to improve performance even further, also it meant that the software could be allot more flexible allowing for quite complex SQL Queries to be built on the fly.

The other draw back to stored procedures was that it was found in version 7, if a SQL Query needed to be changed between versions it meant that allot of users had difficulty in updating the stored procedures on their SQL Server Database.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: dfrancis
Date Posted: 27 July 2006 at 8:01pm

Interesting... were your struggles with making the forum work with mysql? I always understood that stored procedures in sql were easier to manage, easier to code and improved performance.

I'm truly interested in your opinion as I'm in the process of writing some stored procedures at the moment.

Posted By: WebWiz-Bruce
Date Posted: 28 July 2006 at 10:39am

mySQL has nothing to do with it in this case, as mySQL support for Web Wiz Forums was added at a later date.

Stored procedures can give extra performance, but in this case the amount of extra performance is so small it's not worth worrying about.

Allot of the SQL queries in version 8 are written on the fly for greater flexibility so that the user can select more options of how they want the pages displayed. These SQL queries can be quite complex and not really something that can be done easily with stored procedures or at all in some cases.

Also, in version 7 it was found that every time a new version was released that would update any SQL Query the stored procedures also needed to be updated which was very difficult for allot of users, and one of the things that Web Wiz Forums is trying to achieve is ease of setup and use.

Even though from version 7 to version 8 stored procedures where dropped for the SQL Server version, everyone has commented on how much better performance is, with many pages have a 2000% increase.

There are many ways to increase performance without having to go down the complex and troublesome root of stored procedures, epically with the complex, flexible, on the fly SQL used in web wiz forums.

Stored procedures can be very good and can improve performance, but it all depends on your situation. I prefer to use the best, and most practical technology for the situation at hand, instead of using technology, just because you can.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting