Database improvements

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
famdylan Members Profile Find Members Posts Newbie Joined: 12 February 2003 Status: Offline Points: 8	Post Options Post Reply Quote famdylan Report Post Thanks(0) Quote Reply Topic: Database improvements Posted: 27 October 2003 at 9:24pm
	Has anybody proposed going from a recordset approach and using a GetRows method to get the info?

ljamal Members Profile Find Members Posts Mod Builder Group Joined: 16 April 2003 Status: Offline Points: 888	Post Options Post Reply Quote ljamal Report Post Thanks(0) Quote Reply Posted: 27 October 2003 at 10:38pm
	Yes, but that has nothing to do with database improvements. Edited by ljamal
	L. Jamal Walton L. Jamal Inc : Web/ Print Design and ASP Programming

famdylan Members Profile Find Members Posts Newbie Joined: 12 February 2003 Status: Offline Points: 8	Post Options Post Reply Quote famdylan Report Post Thanks(0) Quote Reply Posted: 28 October 2003 at 7:48am
	Wouldn't it though? The database wouldn't be open through the repeated round trips and an improvement in performance could be seen. For example I am working on redoing mine and it has gone from almost 3 seconds average to load (locally) to half a second. Isn't that a database improvement?

ljamal Members Profile Find Members Posts Mod Builder Group Joined: 16 April 2003 Status: Offline Points: 888	Post Options Post Reply Quote ljamal Report Post Thanks(0) Quote Reply Posted: 28 October 2003 at 8:40am
	Nope, that's a scripting improvement. A database improvement would involve a change in the database.
	L. Jamal Walton L. Jamal Inc : Web/ Print Design and ASP Programming

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

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.