Traq Project Forums

Full Version: Use of mysql's 'SELECT *'
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I'm using Traq for a small project and was browsing the source and noticed the SQL queries tend to use 'SELECT *', but much of the information gathered from the DB with the statement is discarded. For example, when creating a new component, the new component page executes a query to get project information using 'SELECT *'. However, it ends up only using the project name and id in the new component form.

I think a more efficient way of gathering data would be to specify the exact fields required.

PS. I wanted to browse the Traq 2.0 source in SVN, but couldn't find a way to actually read the file source in the browser (!).
I agree with you on the queries not being very efficient, but with Traq 2.0 I'm makig sure there are no queries like that.

If you want to browse the source for Traq 2.0 you can get an SVN client and checkout the source.

I recommend TortoiseSVN for Windows, and for Mac OS either Versions or Cornerstone.
Reference URL's