Results 1 to 3 of 3

Thread: [Resolved] SQL: SELECT * FROM question

Threaded View

  1. #1

    Thread Starter
    Stuck in the 80s The Hobo's Avatar
    Join Date
    Jul 2001
    Location
    Michigan
    Posts
    7,256

    [Resolved] SQL: SELECT * FROM question

    What's the difference in speed and memory between doing:

    Code:
    SELECT * FROM tblNames WHERE something='value'
    and:

    Code:
    SELECT phoneNumber FROM tblNames WHERE something='value'
    Is the second method any faster? I suppose it saves up on memory because it isn't returning as much stuff as the first example.

    Is it more efficient to go with the second one?
    Last edited by The Hobo; Jan 17th, 2004 at 03:01 PM.
    My evil laugh has a squeak in it.

    kristopherwilson.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width