Re: pro C versus PL/SQL

I had a similar type of problem few years ago - the "if - else" stuff was for identifying and classifying vehicles by their VIN. I worked out a much faster (and more flexible) solution using dynamic PL/SQL (and some strong exception handling) to invove one of many procedures whose name was based on part of the VIN. It worked really well, perhaps a similar solution might help you (it also makes the code MUCH clearer as you work with descrete procedures - within a package - rather than one big chunk of code).

Regards,

ETA lolitagroux_at_hotmail.com (Lolita) wrote in message news:<8027ad1.0303231736.5f93cf4d_at_posting.google.com>...
> Hi,
>
> I am testing a part of code in pro C and PL/SQL. The code in C takes 2
> minutes to execute while the PL/SQL code takes 7 minutes.
> It would be really easier to code and manage if the program could be
> written in PL/SQL. I would like to know if it is possble to improve
> the PL/SQL performance.
>
> The code does the following:
> 1- Select the data from the database
> 2- For each record seleted it looks through a serie of elsif
> statement, if the record meets the criteria of one elsif statement,
> the data of this record is updated into the database. There can be up
> to 300 elsif statements.
>
> Number 2 takes most of the time.
>
> My questions are the following:
>
> 1- Why C is more performant than PL/SQL?
> 2- Would it be faster to use else if statments instead of elsif
> statments?
> 3- Would it be better to store all the records that have met a elsif
> statment into a PL/SQL table and then loop through the table to update
> them into the database? There can be up to 60000 records to put in the
> PL/SQL.
>
> Thanks in advance
> Lolita
Received on Tue Mar 25 2003 - 04:33:42 CST