Re: Module Pondering

in reply to Module Pondering

As if the legitimate issues regarding selecting too much data, etc., weren't enough....a comment from a different perspective. I seem to recall a few years ago that there were a few databases (vendor-wise) that didn't respond correctly to the select *. Sometimes they returned all of the data, sometimes not. If I remember right, this was a flaw in Microsoft SQL 7 server (yeah, yeah, yeah, we all have our burderns to bear). In addition, though, I have on occasion seen select * not return all of the columns. Sporadic, non repeatable, I know, but the lack of perfect success leads me to suggesting that you should avoid select * whenever possible.

Not to mention the load once your database starts getting to a decent size...

Comment on Re: Module Pondering

Replies are listed 'Best First'.
(jeffa) 2Re: Module Pondering by jeffa (Bishop) on Jan 21, 2002 at 00:30 UTC
Very interesting ... I avoid SQLServer (all versions), but someone emailed about a possible bug with my module, DBIx::XHTML_Table. They said that when using select * in my module with SQLServer7, some of the field names did not show up. Thanks for pointed this out. Takes a load off of me. ;) jeffa L-LL-L--L-LL-L--L-LL-L-- -R--R-RR-R--R-RR-R--R-RR B--B--B--B--B--B--B--B-- H---H---H---H---H---H--- (the triplet paradiddle with high-hat)	[reply]

Replies are listed 'Best First'.

(jeffa) 2Re: Module Pondering
by jeffa (Bishop) on Jan 21, 2002 at 00:30 UTC

I avoid SQLServer (all versions), but someone emailed about a possible bug with my module, DBIx::XHTML_Table. They said that when using select * in my module with SQLServer7, some of the field names did not show up.

Thanks for pointed this out. Takes a load off of me. ;)

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

[reply]

In Section Meditations