Manual code management practices
brian_matthewsbrian matthews
brian_matthews_bmw@hotmail.com
Thu, 19 May 2005 18:18:39 +0000
I have absolutely nothing against using views/cursors - I find that claims
of running at performance increases of 300:1 are totally valid ( when
compared with standard file access to individual tables).
What I should have asked is this 'is it possible to process files in quiz
but in ways other than using the access statement ? ( as is the case with
qtp and sql calls to insert,delete,update and stroed procedures)'.
It would be nice to augment qzc's that have reached the 31 file limit rather
than add additional passes - which is possible with qtp file limits.
P.S. someone commented that a quiz qzc that needs to exceed 31 files must be
a very big report, well I once attempted to add a few lines to quiz source
file and found that it was'nt possible beacause it now exceeded the quiz
internal parsing buffer size - thats big ! :)
regards Bri,
>From: "Johnson, Harold A EDUC:EX" <Harold.A.Johnson@gov.bc.ca>
>To: "'Darren Reely'" <darren.reely@latticesemi.com>, brian_matthewsbrian
>matthews <brian_matthews_bmw@hotmail.com>
>CC: powerh-l@lists.sowder.com
>Subject: RE: Manual code management practices
>Date: Thu, 19 May 2005 08:38:16 -0700
>
>Why not cursors/views??!?!?
>
>
>-----Original Message-----
>From: powerh-l-admin@lists.sowder.com
>[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Darren Reely
>Sent: 2005 May 18 5:50 PM
>To: brian_matthewsbrian matthews
>Cc: powerh-l@lists.sowder.com
>Subject: Re: Manual code management practices
>
>
>
>
>brian_matthewsbrian matthews wrote:
> > many thanks all for the 31 file limit replies ( I forgot to include and
> > not views/cursors ).
>
>Then the answer is NO.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now!
http://toolbar.msn.co.uk/