Results 1 to 10 of 10

Thread: Faster with SELECT * or SELECT Field1, etc.?[Resolved]

Threaded View

  1. Feb 25th, 2004, 10:27 AM #1
    ober0330
    ober0330 is offline

    Thread Starter
    Frenzied Member ober0330's Avatar
    Join Date
    Dec 2001
    Location
    OH, USA
    Posts
    1,945

    Faster with SELECT * or SELECT Field1, etc.?[Resolved]

    I'm wondering if is faster to select all the fields from a db and just not use the ones you don't want, or to pick out the specific fields you're going to use.

    I have a table with ~20 items. I print a report with about 10 of them. Is it faster to do a SELECT * or to do SELECT Field1, Field2, etc (just the fields I want)?

    Edit: Also, this is for several hundred records and not necessarily an ADO/DAO question... I'm actually using MS SQL Server and PHP. I'm wondering more about the theory than the actual working of it.
    Last edited by ober0330; Feb 25th, 2004 at 10:37 AM.
    format your code!! - [vbcode] [/vbcode]

    ANSWERS CAN BE FOUND HERE!!

    my personal company
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width