Stan's slow problem EXPLAIN

[Ruslan Zasukhin]

On 6/1/06 9:52 PM, "Stan Busk" <maxprog at mac.com> wrote:

> Hi,
> 
> With my other problematic app I get huge timings in 'Predicate' line
> (compared to previous app):
> 
> FOR SQL QUERY TIME = 2 :
> DO SELECT : TIME = 2 : ROWS = 1
> DO SIMPLE SELECT : TIME = 2 : ROWS = 1
> DO Single Table Without GROUP BY : TIME = 2 : ROWS = 1
> FOR Table [tblArticle]  DO resolve WHERE statement : TIME = 2 :
> ROWS = 0
> FOR Predicate [AND] TIME = 4290251425 :
> TIME = 4290251425 :
> FOR Field [Article_Status]  DO FindLike : TIME = 2 : ROWS = 0
> 
> and so on...
> 
> Always very big amounts for TIME. Does it correspond to ticks?

I think this is a garbage value. Probably somewhere bug
    
    0 - somevalue = negative = big integer



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]