Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Xbase Fox > Re: & Removal i...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 7 of 8 Topic 801 of 861
Post > Topic >>

Re: & Removal in Expressions

by Cy Welch <cywelch@[EMAIL PROTECTED] > Aug 26, 2007 at 09:15 AM

Gene Wirchenko wrote:
> Bernhard Sander <****hs@[EMAIL PROTECTED]
> wrote:
> 
>>>       select . . .
>>>       where;
>>>        wostatus="B" and &dateexpwo and . . .
> 
>> I think, don't worry about the & in an SQL statement. It is evaluated
only once 
>> for the whole SQL statement, not for every row examined.
>>
>> You should only worry, if you have a (fox-) loop and inside the loop
you build 
>> lots of such SQL statements which return really small result sets. Only
then the 
>> over all execution time may be affected by the &
> 
>      I sometimes have loops with SQL like this in them.
> 
>      I just wrote a re****t program that takes a little over two
> minutes to crunch the data for one test case.  Two minutes is a long
> time.  I tried a couple of likely optimisations, but there was little
> difference in execution time.
> 
>      I do not like writing ugly code, but I want my code to not be
> slow.
> 
How much data are you working with?  And how many queries?  I do find 
that it does seem to work better if I build the entire string then macro 
substitute but it looks like that is what your doing.

-- 
Cy Welch
89 Camaro RS 5.0 TBI
03 Malibu
 




 8 Posts in Topic:
& Removal in Expressions
Gene Wirchenko <genew@  2007-08-23 12:48:42 
Re: & Removal in Expressions
"Lew" <lew@[  2007-08-23 16:18:39 
Re: & Removal in Expressions
"Cathy Pountney"  2007-08-23 18:57:46 
Re: & Removal in Expressions
Thomas Ganss <tganss_a  2007-08-25 13:20:29 
Re: & Removal in Expressions
Bernhard Sander <fuchs  2007-08-24 10:12:33 
Re: & Removal in Expressions
Gene Wirchenko <genew@  2007-08-24 09:13:25 
Re: & Removal in Expressions
Cy Welch <cywelch@[EMA  2007-08-26 09:15:16 
Re: & Removal in Expressions
Gene Wirchenko <genew@  2007-08-27 11:59:48 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 14:18:42 CST 2008.