Re: [ic] SQL Statements

[Michelle Wilant <michelle@wilant.com>]

Big difference -- memory used in the sql call.  Only call what you need -
optimize your queries.  For example, if in the future you added a custom
column to your mysql products table for some text blob, like a description,
the * query will pull all of that information into memory.  Then you are only
going to use a small poriton of it.  By all means only pull what you need.

"joachim.richter" wrote:

> Hi list,
>
> i am in the process of changing some list to use sql statements:
>
> I like to ask the following question:
>
> I have seen both version of the following 2 lines, is there a difference ?
> The fields that are named in the first line are also the ones which are
> in the output list -
>
> select sku, description, price from products where price < '50.00'
> select * from products where price < '50.00'
>
> thanks
>
> JoE
>
> US Video Center Medien GmbH
> Heimsheimer Str 22
> 70499 Stuttgart
>
> Tel 0711 880252 0
> Fax 0711 880252 22
> Email joachim.richter@usvideocenter.de
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users

_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users