Code washing...
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Suggestions
Forum Description: Do you have any ideas for applications or content on Web Wiz? Then leave your suggestions here.
URL: https://forums.webwiz.net/forum_posts.asp?TID=9262
Printed Date: 28 March 2026 at 8:40pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Code washing...
Posted By: weppos
Subject: Code washing...
Date Posted: 26 January 2004 at 3:43pm
|
Creating mods and reading code I have seen that lots of instructions of the site, in particular in admin folder, are writed using ASP+SQL language and not pure SQL code.
FOr example deleting and updating processes often use this sintax and not pure SQL instructions and, as jou (-boRg-) correctly typed into comments, it is not the most lightly way to execute it. -boRg- do you think some of this instruction could be replaced to improve server performance in next versions? 
Unfortunatly some italians providers don't allow to install this application to hosting server cause high resources required (they say!  ) and this could be a way to reduce elaboration weight and to let th forum allowed (I and other italian people hope...).
Do you think it could be done? Excuse me if I'm not be too much understeable into my post... 
|
Replies:
Posted By: MadDog
Date Posted: 26 January 2004 at 3:47pm
|
Changing to add, edit, and delete functions to pure SQL would be nice. A big code clean up for sure. ------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: weppos
Date Posted: 26 January 2004 at 3:55pm
Surely yes, but it could be done slowly changing firt most used functions and proceding into other changing during next releases. Surely server will run much more faster in particular into hosting and not housing plans.
|
MadDog wrote:Posted By: WebWiz-Bruce
Date Posted: 26 January 2004 at 4:26pm
|
Updating the database doesn't happen often so the pages that do use ADO, this is saffer as far as things like SQL injections go. There is one italian host who decided back on an old Access version that they thought it used to many server resourecs, since then I have re-written the forum from the ground up to have better performance and now many web hosts actaully suggest to their users to use this software as it uses less resources then many other ASP forums. Maybe, it's time someone using this Italian hosting company asked them to look at newer versions on web wiz forums, or it maybe that they just don't like any forum that uses Access as Access databases do use allot of resources and course allot of server issues. ------------- 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: weppos
Date Posted: 26 January 2004 at 5:04pm
|
Many thanks for your answer -boRg- .
Unfortunatly it's not the first time we tried (with we I mean hundreds users) to ask this hoster to change their decisions about this applications but without results. Sorry for that, but they still continue to suggest other access db forums. I think we can try ono other time but without many results. Anyway also if pages without pure SQL code are not often use I think it could be helpful to update some instructions. Mine was only a little suggestions so it can be considered or not! 
|