Re: Re: Re: Topics in Perl Programming: Table-Mutation Tolerant Database Fetches with DBI

[swiftone]

in reply to Re: Re: Topics in Perl Programming: Table-Mutation Tolerant Database Fetches with DBI
in thread Topics in Perl Programming: Table-Mutation Tolerant Database Fetches with DBI

But if you select by fields rather than by * as he said, changing the order in the table shouldn't affect your code at all.

[Caillte]

SELECT * FROM blah ORDER BY keyword

Lets face it, most database queries pay little attention to the physical location of the data within the database...

Then again, if we were really wirried about the physical location and order of the information we were accessing would you really argue that a generic database was the best way of storing?

[extremely]

No no no, the '*' is the problem here, we aren't talking row order, we are talking about switching columns around. It's so evil your mind refused to believe it was possible =)

--
$you = new YOU;
honk() if $you->love(perl)