Too many files declared for this run. QTP ending.

[Daniel Rodríguez]

Hi Ken,

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...

We will study more carefully the creation of indexes in the future...  Thank
you very much!

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...

Best regards,

Daniel Rodriguez.


2007/10/2, Ken Langendock <Ken at langendock.com>:
>
>  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.
>
> LINK a, b to a,b in mytable is all you need to do.
>
> Adding Cursors will definitely speed it up 10 fold.
>
> Ken
>
>  ------------------------------
> *From:* powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com[mailto:
> powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] *On Behalf Of
> *Daniel Rodríguez
> *Sent:* October 2, 2007 5:45 AM
> *To:* Franck LERAY
> *Cc:* powerh-l at lists.sowder.com
> *Subject:* Re: Too many files declared for this run. QTP ending.
>
> Ok, I will try to replace some lines of code with SQL statements and we'll
> see...
>
> Thanks,
>
> Dani
>
> 2007/10/2, Franck LERAY <franck.leray at cheops.fr >:
> >
> >  Hi Daniel,
> >
> >
> >
> > Mmm, I think there's a difference of one file between HP3000 and UNIX.
> > Oh, I can't explain why!!!
> >
> >
> >
> > Regards,
> >
> >
> >
> > Franck.
> >
> >
> >  ------------------------------
> >
> > *De :* powerh-l-bounces+franck.leray=cheops.fr at lists.sowder.com [mailto:
> > powerh-l-bounces+franck.leray=cheops.fr at lists.sowder.com] *De la part de
> > * Daniel Rodríguez
> > *Envoyé :* mardi 2 octobre 2007 10:02
> > *À :* powerh-l at lists.sowder.com
> > *Objet :* Too many files declared for this run. QTP ending.
> >
> >
> >
> > Hi all,
> >
> > 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.
> >
> > We haven't added any file to the QTP in the migration process. We have
> > only added the VIAINDEX keyword in the access statement.
> >
> > Has the file limit been decreased in the new version? Or, QTP counts
> > files and subfiles in a different way in this version?
> >
> > Regards,
> >
> > Daniel Rodriguez Olías
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20071002/a3d38036/attachment.htm