Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - db help please
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

db help please
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 06 December 2004 at 9:26am
Originally posted by Mart Mart wrote:

Originally posted by MadDog MadDog wrote:

Originally posted by Gullanian Gullanian wrote:

When only selecting from one table you don't need to write tablename. in the select part.  This makes reading the code easier.


Makes it easier yes, makes the server work harder, YES.


Where did you get that info from? I don't think it would make the server work that much harder
 
My understanding is the same as maddogs, but I couldn't give a specific source other than that an explicit reference is usually faster than a generic one.

Lead me not into temptation... I know the short cut, follow me.
Back to Top
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post Posted: 06 December 2004 at 10:14am
I understand that explicitness is faster than generic, but is this the case when only 1 table is being referenced?
Back to Top
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post Posted: 14 December 2004 at 11:38am
Anyone found out what happens yet?
Back to Top
 Post Reply Post Reply Page  <12

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.