unit_id is primary key and this table(m_unit ) has hardly 20 records
On Tuesday, February 24, 2015 3:43 PM, "Svein Erling Tysvær
[email protected] [firebird-support]"
<[email protected]> wrote:
> Select first(1) u.UNIT_ID from m_unit u
> where (upper(trim(u.UNIT_NAME))= upper(trim(:MAIN_UNIT))
> or upper(trim(u.UNIT_SYMBOL))=upper(trim(:MAIN_UNIT)))
> and coalesce(CONVERSION_UNIT_ID,0)=0 Into :Main_Unit_Id;
Does this select use any index at all? How many records are there in M_UNIT
(and similarly for other tables referred in a similar manner in this stored
procedure or its sub-procedures)? Generally, using functions on fields normally
means they don't use indexes (computed indexes being the exception). Unless
such tables are small, calling this procedure 100000 times could well be the
reason for your program taking over 10 hours.
I'll try to look a bit closer at this procedure later today, though I'm not
certain I will get the opportunity.
Set
#yiv0339561696 #yiv0339561696 -- #yiv0339561696ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0339561696
#yiv0339561696ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0339561696
#yiv0339561696ygrp-mkp #yiv0339561696hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0339561696 #yiv0339561696ygrp-mkp #yiv0339561696ads
{margin-bottom:10px;}#yiv0339561696 #yiv0339561696ygrp-mkp .yiv0339561696ad
{padding:0 0;}#yiv0339561696 #yiv0339561696ygrp-mkp .yiv0339561696ad p
{margin:0;}#yiv0339561696 #yiv0339561696ygrp-mkp .yiv0339561696ad a
{color:#0000ff;text-decoration:none;}#yiv0339561696 #yiv0339561696ygrp-sponsor
#yiv0339561696ygrp-lc {font-family:Arial;}#yiv0339561696
#yiv0339561696ygrp-sponsor #yiv0339561696ygrp-lc #yiv0339561696hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0339561696
#yiv0339561696ygrp-sponsor #yiv0339561696ygrp-lc .yiv0339561696ad
{margin-bottom:10px;padding:0 0;}#yiv0339561696 #yiv0339561696actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0339561696
#yiv0339561696activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0339561696
#yiv0339561696activity span {font-weight:700;}#yiv0339561696
#yiv0339561696activity span:first-child
{text-transform:uppercase;}#yiv0339561696 #yiv0339561696activity span a
{color:#5085b6;text-decoration:none;}#yiv0339561696 #yiv0339561696activity span
span {color:#ff7900;}#yiv0339561696 #yiv0339561696activity span
.yiv0339561696underline {text-decoration:underline;}#yiv0339561696
.yiv0339561696attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0339561696 .yiv0339561696attach div a
{text-decoration:none;}#yiv0339561696 .yiv0339561696attach img
{border:none;padding-right:5px;}#yiv0339561696 .yiv0339561696attach label
{display:block;margin-bottom:5px;}#yiv0339561696 .yiv0339561696attach label a
{text-decoration:none;}#yiv0339561696 blockquote {margin:0 0 0
4px;}#yiv0339561696 .yiv0339561696bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0339561696
.yiv0339561696bold a {text-decoration:none;}#yiv0339561696 dd.yiv0339561696last
p a {font-family:Verdana;font-weight:700;}#yiv0339561696 dd.yiv0339561696last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0339561696
dd.yiv0339561696last p span.yiv0339561696yshortcuts
{margin-right:0;}#yiv0339561696 div.yiv0339561696attach-table div div a
{text-decoration:none;}#yiv0339561696 div.yiv0339561696attach-table
{width:400px;}#yiv0339561696 div.yiv0339561696file-title a, #yiv0339561696
div.yiv0339561696file-title a:active, #yiv0339561696
div.yiv0339561696file-title a:hover, #yiv0339561696 div.yiv0339561696file-title
a:visited {text-decoration:none;}#yiv0339561696 div.yiv0339561696photo-title a,
#yiv0339561696 div.yiv0339561696photo-title a:active, #yiv0339561696
div.yiv0339561696photo-title a:hover, #yiv0339561696
div.yiv0339561696photo-title a:visited {text-decoration:none;}#yiv0339561696
div#yiv0339561696ygrp-mlmsg #yiv0339561696ygrp-msg p a
span.yiv0339561696yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0339561696
.yiv0339561696green {color:#628c2a;}#yiv0339561696 .yiv0339561696MsoNormal
{margin:0 0 0 0;}#yiv0339561696 o {font-size:0;}#yiv0339561696
#yiv0339561696photos div {float:left;width:72px;}#yiv0339561696
#yiv0339561696photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0339561696
#yiv0339561696photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0339561696
#yiv0339561696reco-category {font-size:77%;}#yiv0339561696
#yiv0339561696reco-desc {font-size:77%;}#yiv0339561696 .yiv0339561696replbq
{margin:4px;}#yiv0339561696 #yiv0339561696ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0339561696 #yiv0339561696ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0339561696
#yiv0339561696ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0339561696
#yiv0339561696ygrp-mlmsg select, #yiv0339561696 input, #yiv0339561696 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0339561696
#yiv0339561696ygrp-mlmsg pre, #yiv0339561696 code {font:115%
monospace;}#yiv0339561696 #yiv0339561696ygrp-mlmsg *
{line-height:1.22em;}#yiv0339561696 #yiv0339561696ygrp-mlmsg #yiv0339561696logo
{padding-bottom:10px;}#yiv0339561696 #yiv0339561696ygrp-msg p a
{font-family:Verdana;}#yiv0339561696 #yiv0339561696ygrp-msg
p#yiv0339561696attach-count span {color:#1E66AE;font-weight:700;}#yiv0339561696
#yiv0339561696ygrp-reco #yiv0339561696reco-head
{color:#ff7900;font-weight:700;}#yiv0339561696 #yiv0339561696ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0339561696 #yiv0339561696ygrp-sponsor
#yiv0339561696ov li a {font-size:130%;text-decoration:none;}#yiv0339561696
#yiv0339561696ygrp-sponsor #yiv0339561696ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0339561696
#yiv0339561696ygrp-sponsor #yiv0339561696ov ul {margin:0;padding:0 0 0
8px;}#yiv0339561696 #yiv0339561696ygrp-text
{font-family:Georgia;}#yiv0339561696 #yiv0339561696ygrp-text p {margin:0 0 1em
0;}#yiv0339561696 #yiv0339561696ygrp-text tt {font-size:120%;}#yiv0339561696
#yiv0339561696ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0339561696
