title: PHP & SQL Query Efficieny for * or Specific Columns
body: <p>I have an Oracle database view in which I have access to 17 columns and approximately 15k rows (this grows at a rate of about 700 rows per year). I only need to use 10 of the columns. At the moment I am searching for ways to make my query more efficient since my app load about 7.5k of the entries at first. I know I could only load lets say 1k entries and that would be a way to speed up the loading process; however, the users often need to query through more than the 1k entries loaded initially, and I do not want to make them wait through a second loading of data into the app.</p>
  
  <p>So I guess my main question is that when I query the Oracle view should I query and just do a * query on the database or select specific columns? I know that best practices state only query the columns you need; however, I am looking at this from a performance standpoint and would I see a significant performance increase by only querying the 10 specific columns I need rather than a * query on the view?   </p>