List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:October 28 1999 6:28pm
Subject:Re: PERL DBI Driver Speed
View as plain text  
>>>>> "TVR" == Todd V Rovito <todd.rovito@stripped> writes:

TVR> have to reinvent the wheel.  If you use fetchrow_array and you
TVR> change the table structure you need to renumber all of your index
TVR> numbers in all of your programs. Is there a better way? I wonder

If you need to do this, then your SQL queries are bad.  You should
always specify exactly the fields you want, not "SELECT * FROM...".
It *will* come back and bite you in the rear.  If not today, then a
year from now, or even later.  Your apps should protect themselves
from changes to the database as best they can.

Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       +1-301-545-6996
PGP & MIME spoken here  
PERL DBI Driver SpeedTodd V. Rovito28 Oct
  • Re: PERL DBI Driver SpeedVivek Khera28 Oct
    • RE: PERL DBI Driver SpeedDan Ray28 Oct
      • RE: PERL DBI Driver SpeedVivek Khera28 Oct
        • RE: PERL DBI Driver Speedxcxsxvx28 Oct
  • Re: PERL DBI Driver Speedsasha28 Oct