Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Code washing...
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Code washing...

 Post Reply Post Reply
Author
weppos View Drop Down
Groupie
Groupie


Joined: 23 May 2003
Status: Offline
Points: 173
Post Options Post Options   Thanks (0) Thanks(0)   Quote weppos Quote  Post ReplyReply Direct Link To This Post Topic: Code washing...
    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...
Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008
Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
weppos View Drop Down
Groupie
Groupie


Joined: 23 May 2003
Status: Offline
Points: 173
Post Options Post Options   Thanks (0) Thanks(0)   Quote weppos Quote  Post ReplyReply Direct Link To This Post Posted: 26 January 2004 at 3:55pm
Originally posted by MadDog MadDog wrote:

Changing to add, edit, and delete functions to pure SQL would be nice. A big code clean up for sure.


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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
weppos View Drop Down
Groupie
Groupie


Joined: 23 May 2003
Status: Offline
Points: 173
Post Options Post Options   Thanks (0) Thanks(0)   Quote weppos Quote  Post ReplyReply Direct Link To This Post 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!
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.