Hi Ken,<br><br>We were told that QTP was not very fast without creating alternative index so we have created many search keys in Oracle. We are converting to the new enviroment our first QTP's now I realize that the performance it's not so bad without indexes...
<br><br>We will study more carefully the creation of indexes in the future... Thank you very much!<br><br>But, my problem with the number of files still exists. I've removed all the viaindex, replaced a 3 file access statement with one cursor and the problem continues... I'm going slightly mad... I think we will split in 2 all those big QTP's... but it's a little bit annoying...
<br><br>Best regards,<br><br>Daniel Rodriguez.<br><br><br><div><span class="gmail_quote">2007/10/2, Ken Langendock <<a href="mailto:Ken@langendock.com">Ken@langendock.com</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Daniel, why did you use VIAINDEX statements when using
Oracle? My rule of thumb is to have only one Primary/Unique index in a file and
allow Oracle to control the access method itself. It is smart enough to know the
fastest way of retrieving the results you want without being told what index to
use.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">LINK a, b to a,b in mytable is all you need to
do.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Adding Cursors will definitely speed it up 10
fold.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Ken</font></span></div><br>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b>
powerh-l-bounces+ken.langendock=<a href="mailto:rogers.com@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">rogers.com@lists.sowder.com</a>
[mailto:<a href="mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com</a>]
<b>On
Behalf Of </b>Daniel Rodríguez<br><b>Sent:</b> October 2, 2007 5:45
AM<br><b>To:</b> Franck LERAY<br><b>Cc:</b>
<a href="mailto:powerh-l@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l@lists.sowder.com</a><br><b>Subject:</b> Re: Too many files declared for
this run. QTP ending.<br></font><br></div><div><span class="e" id="q_11560b678650d43b_1">
<div></div>Ok, I will try to replace some lines of code with SQL statements and
we'll see...<br><br>Thanks,<br><br>Dani<br><br>
<div><span class="gmail_quote">2007/10/2, Franck LERAY <<a href="mailto:franck.leray@cheops.fr" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">franck.leray@cheops.fr </a>>:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div vlink="purple" link="blue" lang="FR">
<div>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB">Hi
Daniel,</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB"></span></font> </p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB">Mmm, I think there's
a difference of one file between HP3000 and UNIX. Oh, I can't explain
why!!!</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB"></span></font> </p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB">Regards,</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB"></span></font> </p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; color: navy; font-family: Arial;" lang="EN-GB">Franck.</span></font></p>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;" lang="EN-GB"></span></font> </p></div>
<div>
<div style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">
<hr align="center" size="2" width="100%">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="font-weight: bold; font-size: 10pt; font-family: Tahoma;">De :</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;">
powerh-l-bounces+franck.leray=<a href="mailto:cheops.fr@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">cheops.fr@lists.sowder.com</a> [mailto:<a href="mailto:powerh-l-bounces+franck.leray=cheops.fr@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
powerh-l-bounces+franck.leray=cheops.fr@lists.sowder.com</a>]
<b><span style="font-weight: bold;">De la part de</span></b> Daniel
Rodríguez<br><b><span style="font-weight: bold;">Envoyé :</span></b> mardi
2 octobre 2007 10:02<br><b><span style="font-weight: bold;">À :</span></b>
<a href="mailto:powerh-l@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l@lists.sowder.com</a><br><b><span style="font-weight: bold;">Objet :</span></b> Too many files declared for
this run. QTP ending.</span></font></p></div>
<div><span>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"></span></font> </p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Hi
all,<br><br>When compiling a big QTP migrated from
HP3000/MPE/TurboImage/Powerhouse 7.29 to HP9000/Hp-UX/Oracle 10.2/Powerhouse
8.43.D1 we get the following error: "Too many files declared for this run. QTP
ending." and it exits from QTP. <br><br>We haven't added any file to the QTP
in the migration process. We have only added the VIAINDEX keyword in the
access statement.<br><br>Has the file limit been decreased in the new version?
Or, QTP counts files and subfiles in a different way in this version?
<br><br>Regards,<br><br>Daniel Rodriguez
Olías</span></font></p></span></div></div></div></blockquote></div><br></span></div></div>
</blockquote></div><br>