Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

Re: Module Pondering

by z3d (Scribe)
on Jan 21, 2002 at 00:23 UTC ( #140239=note: print w/replies, xml ) Need Help??

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...

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. ;)


    (the triplet paradiddle with high-hat)

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://140239]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (3)
As of 2023-03-28 21:36 GMT
Find Nodes?
    Voting Booth?
    Which type of climate do you prefer to live in?

    Results (69 votes). Check out past polls.