Results 1 to 2 of 2

Thread: Is this significantly faster?

  1. #1
    Join Date
    Jun 2006
    Under your bed

    Is this significantly faster?

    Say I could use either of these two queries:

    SELECT `name`, `age` FROM `people` WHERE `person_id` = '1';


    SELECT `name`, `age`, `address`, `email` FROM `people` WHERE `person_id` = '1';

    Would the first one be significantly faster?
    The better I get at programming, the more I appreciate arrays. Handy dandy things they are.

  2. #2
    Join Date
    Aug 2004
    I doubt there would be a measurable difference. Maybe if one of the additional fields in the second query contained large amounts of data, there would be some additional time needed on each row fetch to copy that data from the DB to the application memory -- but if you need that data, then you'll have to use that time anyway -- and if you don't need that data, then why would you want it in the query results in the first place?
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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