Re: VFP's Enginebehavior

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Durby,

according to the help, there are a few changes affected by the SET
ENGINEBEHAVIOR-setting.
If you want to spped up your queries, you might take a look in the help
under:
"Whats new in Visual Foxpro" -> "Data and XML Feature Enhancements". There
is a chapter called "Binary Index Tag Based on Logical Expressions" which
might be interesting.

--
Cheers
Carsten
_______________________________

"Durby vend" <someone@xxxxxxxxxxxxx> schrieb im Newsbeitrag
news:ubUe0lZcFHA.4028@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
> I know the diff of this.
> i mean what is the benefit of if using engine90 ?
> is it faster or any other gain from it.
>
> Thanks for your respond.
>
>
> "Carsten Bonde" <bonde AT real-inkasso DOT de> wrote in message
> news:OdcHBXZcFHA.3504@xxxxxxxxxxxxxxxxxxxxxxx
> > Durby,
> >
> > Here is a small example demonstrating the GROUP BY - change needed after
> > 70.
> > For more info please refer to the help on "SET ENGINEBEHAVIOR"
> >
> > <snip>
> > CREATE TABLE test12(nNum I, cVal C(10), cVal2 c(10))
> > INSERT INTO test12 VALUES (1, "Fld1", "Fld2-1" )
> > INSERT INTO test12 VALUES (2, "Fld1", "Fld2-2" )
> > INSERT INTO test12 VALUES (3, "Fld1", "Fld2-3" )
> >
> > *1 - Bad
> > *SET ENGINEBEHAVIOR 80
> > *SELECT sum(nnum), cval FROM test12
> >
> > *2 - Good
> > *SET ENGINEBEHAVIOR 70
> > *SELECT sum(nnum), cval FROM test12
> >
> > * 3 - Good
> > *SET ENGINEBEHAVIOR 80
> > *SELECT sum(nnum), cval FROM test12 GROUP BY cval
> > <snip>
> >
> > --
> > Cheers
> > Carsten
> > _______________________________
> >
> > "Durby vend" <someone@xxxxxxxxxxxxx> schrieb im Newsbeitrag
> > news:eayVyMXcFHA.3808@xxxxxxxxxxxxxxxxxxxxxxx
> >> What's the benefit gain from VFP9 with engineBehavior 90?
> >> what is the diff if using VFP9 with engineBehavior set to 70 ?
> >>
> >>
> >
> >
>
>


.